Mock interview. You're interviewing for a data analyst job on a music streaming team. The interviewer opens a shared editor, points you to the streams and users tables, and asks two questions in a row.
One house rule matters: a play only counts as a stream if it lasted at least 30 seconds (ms_played >= 30000). Shorter plays are skips.
"Before we dig in, give me June 2026 in one row." Show the number of plays (every row), streams (plays of 30 seconds or more), listeners (people with at least one stream) and streams per listener.
Expected output
streams_per_listener rounded to 2 decimalsExample of the shape (made-up values):
| plays | streams | listeners | streams_per_listener |
|---|---|---|---|
| 3100 | 2400 | 610 | 3.93 |
Hints, the later steps and the answer come with Pro.
Step 1 of 2
Write your query here. Ctrl + Enter submits.