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 platform's 2026 retrospective spotlights the longest piece in each content format, drawn from everything published since 2026. Return the content items whose runtime is the longest ever recorded for their format, with their unique content IDs and titles.
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