Session Page View Distance
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
The UX research team is studying engagement depth within sessions. For each session, measure the distance between its first and last page view as the difference in their dur_ms, then return the average distance across sessions. Page views connect to sessions through user_id.
Summary
Page view distance per session.
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