Daily active users
Count the unique active users per day from the a_events table (the day comes from the event time ts). Return day and dau, ordered by day.
Expected output sample
This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables.
| dau | day |
|---|---|
| 3 | 2024-01-05 |
| 2 | 2024-01-06 |
| 1 | 2024-01-07 |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign in