I have a table of this format which has Employee ID, Snapshot Date and 'Opt In' status (Opt in status is response from Employees whether they want to receive text alerts or not), they can change their response and each day status get snapshotted in table like this. If they don't change their status will be same as previous day. To begin with they will have response of 'TRUE'.
I am looking for ways how to write query to see Employee IDs who chosen to opt in to receive texts atleast twice. e.g. Employee 102 should be part of this list where he changed his status from TRUE>FALSE>TRUE
|Employee ID||Snapshot Date||Opt In Status|