Fastest Page View to Click
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
We log one shared stream of product events, each with a type, a user and a timestamp. A browsing event (a page view, a search or an open) is a transition when the event right after it in the stream is a button click; return the three fastest transitions with the browsing user, the browsing type, both timestamps and the gap in seconds, plus the average gap across all transitions.
Summary
How fast from view to click?
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