Top Content by Lifetime Value
A medium SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- L4
Interview Prompt
The content team wants the most-watched content overall, where a view counts toward a piece of content whenever its creator was the one browsing: treat any page view by a creator as a view of all their work. Add up those view durations to get each item's lifetime value, and surface the strongest items with their content ID, title, and lifetime value.
Summary
Lifetime value. Measured in total watch time.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write your sql solution with real code execution
- Get instant feedback and a hire/no-hire decision