How many of each event
SQLEasy7 min
Your task
Count how many times each event name occurs. Return name and times, most frequent first, then alphabetically.
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 |
Model answerRun