Mock interview. You're interviewing for a data analyst job on a streaming service's product team. The interviewer shares the watch_sessions table, one row per time someone pressed play. "Let's look at March."
"Give me March 2026 in one row: sessions, unique viewers, total hours watched and hours per viewer."
Expected output
hours rounded to 1 decimal; hours_per_viewer rounded to 2 decimalsExample of the shape (made-up values):
| sessions | viewers | hours | hours_per_viewer |
|---|---|---|---|
| 600 | 350 | 520.0 | 1.49 |
Hints, the later steps and the answer come with Pro.
Step 1 of 2
Write your query here. Ctrl + Enter submits.