Device Type Serving Most Users
A medium SQL mock interview question on DataDriven, with an AI interviewer who asks follow-up questions and a hire or no-hire decision at the end.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- L4
Interview Prompt
We track user sessions and the device each one ran on, and the device team's reach report keeps naming one winner. List every device type whose unique users reach at least 90% of the top device type's count, with that count.
Summary
One device type serves more users than the rest.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write and run your SQL against a real database
- Answer the interviewer's follow-up questions, then get a hire or no-hire decision