Loading...
Top Content by Watch Time
A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- mid
Problem
Only consider views where watch duration is recorded. Rank all content by total watch time across all viewers and return the top 3 tiers. If multiple items share the same total, include all of them. Show the content ID, title, and total watch time.
Practice This Problem
Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a live PostgreSQL database and grades it instantly.