Where the Minutes Go
A hard 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
- hard
- Seniority
- L5
Interview Prompt
Our analytics warehouse stores one row per page view, tagged with the visitor's device and how long they stayed on the page. Total the time on page for each device type, and next to each device show the cumulative share of overall time accounted for when devices are counted from the biggest total down through that one.
Summary
Attention piles up device by device. Find where it pools.
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