Platform Speed
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
- L3
Interview Prompt
The product team is investigating whether device type affects how long users stay engaged. For each device type, show the typical session length, the longest session on record, and how many sessions were logged. Only include device types that have at least five sessions in the data , anything with fewer isn't statistically meaningful. List from the device type with the longest average session down to the shortest.
Summary
Which devices keep users longest?
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