Cumulative distinct users by day
SQLHard15 min
Your task
For each day that had events, return occurred_on and users_so_far: how many distinct users had been seen up to and including that day. Order by date.
Tables
app_user| idINTEGER | nameTEXT | planTEXT | joined_onTEXT |
|---|
| 1 | Ari | free | 2026-01-02 |
| 2 | Bea | pro | 2026-01-02 |
| 3 | Cai | free | 2026-01-15 |
| 4 | Dot | pro | 2026-02-01 |
| 5 | Eli | free | 2026-02-20 |
event| idINTEGER | user_idINTEGER | nameTEXT | occurred_onTEXT | session_idTEXT |
|---|
| 1 | 1 | signup | 2026-01-02 | s1 |
| 2 | 1 | view | 2026-01-02 | s1 |
| 3 | 1 | view | 2026-01-03 | s2 |
| 4 | 2 | signup | 2026-01-02 | s3 |
| 5 | 2 | view | 2026-01-02 | s3 |
| 6 | 2 | purchase | 2026-01-02 | s3 |
More rows not shown Model answerRun