Session Page View Distance

A hard SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.

Domain

SQL

Difficulty

hard

Seniority

L5

Problem

The UX research team is studying engagement depth within sessions. For each session, identify the first and last page view by view_id, then compute the distance as the last view's dur_ms minus the first view's dur_ms. Discard any session that contains only a single view. Return the average distance across all qualifying sessions. Sessions are linked to page views through user_id.

Summary

Page view distance per session.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and grades it automatically.