Task

Chime’s Product Growth team wants to identify members who were active on three consecutive calendar days in the Chime app. Write a SQL query to find users who completed at least one 3-day activity streak.

Use the app_events table, where each row is an in-app event. A user is considered active on a day if they generated at least one event on that date.

Requirements

1. Deduplicate multiple events from the same user on the same day.
2. Treat consecutive activity as calendar-day continuity (2024-03-01, 2024-03-02, 2024-03-03).
3. Return one row per qualifying streak, including the user_id, streak_start_date, streak_end_date, and active_days_in_streak.
4. Only return streaks with exactly 3 consecutive days in the detected window.
5. Sort the final output by streak_start_date, then user_id.

Table Definition

Sample Data

Expected Output