Session Page View Distance
A hard SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- 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 your sql solution with real code execution
- Get instant feedback and a hire/no-hire decision