The Longest Take
A easy SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- easy
- Seniority
- L4
Interview Prompt
A media library wants to spotlight the longest piece in each content format. Find the content items whose duration is the highest for their content type and that were published since 2026, and return each item's content ID and title.
Summary
The content that held the number-one spot.
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