The Crowded Hour
An easy 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
- easy
- Seniority
- L5
Interview Prompt
We size capacity per device type to its worst-case crowding, not its average, and this quarter there is only budget to reinforce the three most strained types. Using user_sessions and devices, find each type's busiest rolling 45-day window, the stretch with the most different people active, and report those three types with that peak headcount and the window it covers, most crowded first.
Summary
Every device type has a moment when the room is fullest. Find it.
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