Mock interview. You're interviewing for a senior data scientist job on a creator tools team. The interviewer says: "We tell creators to use trending sounds. Is that good advice? Convince me with data, and be fair about it."
Use videos posted before 1 June 2026, so every video has had at least a few weeks to collect views. uses_trending_sound is true when the video uses a sound that was trending when it was posted.
"Start simple: videos with a trending sound versus without. How many videos, average views per video, and completion rate?"
watch_sec >= duration_sec.Expected output
avg_views and completion_rate (a percentage) rounded to 1 decimal; sorted by uses_trending_soundExample of the shape (made-up values):
| uses_trending_sound | videos | avg_views | completion_rate |
|---|---|---|---|
| false | 300 | 10.0 | 35.0 |
Hints, the later steps and the answer come with Pro.
Step 1 of 4
Write your query here. Ctrl + Enter submits.