Trending Sound ID
ASKED IN INTERVIEWTik Tok
Problem Statement
The TikTok content team wants to identify the single most viral sound of the day. A sound is considered trending based on the sheer number of unique videos that used it within a 24-hour period.
Write an SQL query to find the sound_id that was used in the most videos published on 2026-02-11.
Rules:
- Only consider videos published on 2026-02-11.
- If there is a tie, return the sound with the lower sound_id.
- Output columns: sound_id, video_count.
Table Schema:
- Videos: video_id, creator_id, sound_id, upload_date.
Tests your understanding of
Basic SQL, Aggregation, Grouping and Ordering
Input Tables
Videos
| video_id(INTEGER) | sound_id(INTEGER) | upload_date(DATE) |
|---|---|---|
| 1 | 501 | 2026-02-11 |
| 2 | 502 | 2026-02-11 |
| 3 | 501 | 2026-02-11 |
| 4 | 503 | 2026-02-11 |
| 5 | 502 | 2026-02-11 |
| 6 | 502 | 2026-02-11 |
| 7 | 501 | 2026-02-10 |
Expected Output
| sound_id(INTEGER) | video_count(INTEGER) |
|---|---|
| 502 | 3 |
Tags
EasyASKED IN INTERVIEWBasic SQLAggregationGroupingOrdering
5-10 min
81%