This is where we have to get ready.
Now, if I quizzed you on this-- and I love to quiz people--
and I said to you, did this database
come from an Android or an iPhone, how many of you
would actually know that answer?
Most people would look at the body
and hope that it said iPhone or Android
and start scanning like crazy.
There are no datetime stamps shown here as a clue.
But what you are going to see, the column headers.
Look how they all start with the Z.
So we see ZFLAGS, Z_OPT, ZSTATE, ZTYPE, ZBODY.
It's not to make me sound like a psychopath
when I teach you this.
It is a clue that it's an Apple device.
So this is actually an iPhone.
You're not going to find that Z in a column name on Android.
So that's a good clue for you.
Now, when you look at this, a query
is going to enable you to say, only show me what I care about.
So if you only care about ZBODY, ZSTATE,
maybe ZTIMESTAMP, ZTYPE, tell it that,
and it will show you only those things.