Mock interview. You're interviewing for a data analyst job on a short-video app's content team. The interviewer shares views (one row per time someone watched a video) and videos, and asks two quick questions.
A view is completed when the person watched at least the whole video: watch_sec >= duration_sec. People can loop a video, so watch_sec can be longer than the video.
"How did May 2026 look? One row: total views, unique viewers, average watch time per view in seconds, and the completion rate."
Expected output
avg_watch_sec rounded to 1 decimal; completion_rate as a percentage rounded to 1 decimalExample of the shape (made-up values):
| views | viewers | avg_watch_sec | completion_rate |
|---|---|---|---|
| 2500 | 700 | 25.0 | 40.0 |
Hints, the later steps and the answer come with Pro.
Step 1 of 2
Write your query here. Ctrl + Enter submits.