The Upgrade Divide
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
Our growth team wants to know how far iOS 16, 17, and 18 have spread across our age groups. For each age group, show the number of users who ran a session on one of those iOS versions next to the total number of users with any session, largest groups first.
Summary
The install numbers don't match the hype.
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