SQL to get 2 adjacent actions from the flag

hope you are doing well!

I have an dummy data as below.

I want to get 2 adjacent actions from the flag by each user.

Here's the chart to describe my thought.

Here's what I want:

How can I implement SQL(I use Google Bigquery)? Hope someone can light me up. Thanks a million!

https://stackoverflow.com/questions/66044663/sql-to-get-2-adjacent-actions-from-the-flag February 04, 2021 at 07:27PM