Top Content by Watch Time
A medium SQL mock interview question on DataDriven, with an AI interviewer who asks follow-up questions and a hire or no-hire decision at the end.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- L4
Interview Prompt
On a media platform, attention is measured as the total watch time a piece of content collects across its views, and the programming team wants the leaders. Using the content items and their views, return the top three by total watch time with each item's content ID, title and total watch time, highest first.
Summary
Some content holds attention. Others get skipped.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write and run your SQL against a real database
- Answer the interviewer's follow-up questions, then get a hire or no-hire decision