Self-Join and Window Patterns

Write a query utilizing a self-join and window functions to identify user engagement patterns across consecutive days on Roku.

Use daily_user_activity as the source table. Treat activity dates as consecutive when they differ by exactly one calendar day.

Output

1. One row per user with a consecutive-day activity pair.
2. Columns: user_id, first_activity_date, next_activity_date, first_day_sessions, next_day_sessions, and pair_number.
3. Exclude users without a consecutive-day pair. Order by user_id, then first_activity_date.