Mock interview. You're interviewing for a product analyst job on a streaming service. The interviewer says: "Hours watched have been falling since March. The content team is worried the new shows are flopping. What do you think is going on?" You have watch_sessions and users.
"Show hours watched for each month of 2026, with the percentage change from the month before."
Expected output
hours rounded to 1 decimal; pct_change rounded to 1 decimal, empty for January; sorted by monthExample of the shape (made-up values):
| month | hours | pct_change |
|---|---|---|
| 2026-01-01 | 400.0 | |
| 2026-02-01 | 380.0 | -5.0 |
Hints, the later steps and the answer come with Pro.
Step 1 of 3
Write your query here. Ctrl + Enter submits.