Multi-OS Users
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 downstream consumer flagged missing cross-platform users. Find users who have logged in from devices running different operating systems across sessions. A user qualifies if they have more than one unique OS name. Return all session records for qualifying users, including user ID, OS name, device type, and session start.
Summary
iOS today, Android tomorrow.
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