Mock interview. You're interviewing for a product analyst job on a music streaming team. The interviewer says: "Our skip rate has crept up this year and nobody knows why. Let's find out together." They point you to the streams table.
A skip is a play shorter than 30 seconds (ms_played < 30000). The skip rate is skips as a percentage of all plays.
"First, show me the skip rate for each month of 2026, and how many points it moved from the month before."
Expected output
skip_rate as a percentage rounded to 1 decimal; change_pts is this month minus last month (empty for January); sorted by monthExample of the shape (made-up values):
| month | plays | skip_rate | change_pts |
|---|---|---|---|
| 2026-01-01 | 500 | 12.0 | |
| 2026-02-01 | 550 | 13.5 | 1.5 |
Hints, the later steps and the answer come with Pro.
Step 1 of 3
Write your query here. Ctrl + Enter submits.