OK, behind the scenes, what are we going to do?
We have a table called ZKIKMESSAGE.
We want to see the user, the timestamp, the timestamp,
the body.
Now, look at that, timestamp, timestamp.
This is where people are like, what is the difference?
Create test data.
That is my best advice to you.
Create test data that is going to say what you think it is.
Download KIKMESSAGE.
Send a message.
One is probably sent.
One is probably received.
You could have different updates.
There's all kinds of things.
So what we need to do is we need to write a query that says,
show us just these things.
If I quizzed you on timestamps right now, if I said,
what's a second indicator that this came from an iOS device?
Your answer should be the timestamp.
So this timestamp, it starts with a 4.
If it starts with a 4, it's going
to be a Mac timestamp, very important to remember.
And I'm going to keep giving you these hints on these timestamps
and quizzing you, even though you're not answering me.
In my mind, you're answering me.
I'm going to keep quizzing you on this.
So we have the Z, and that timestamp starts with a 4.
It's 100% Apple.