How to determine if records (for a certain set) follow a correct order?-CodePudding

Home > Software design > How to determine if records (for a certain set) follow a correct order?

How to determine if records (for a certain set) follow a correct order?

Time：11-14

I have a table that contains 3 different status'

1. CLICKED
2. CLAIMED
3. BOUGHT

In this particular order. I am trying to determine if there were any records that did not occur in the right order based on their date.

For example, this is the data: