Average Event Progression Time

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

Domain

SQL

Difficulty

hard

Seniority

mid, senior

Problem

The onboarding team believes users who move quickly between events are more likely to convert, but they have no data to prove it. For every user with more than one event, compute the average number of seconds between consecutive events so the team can segment fast movers from slow ones. Return each qualifying user and their average gap, ordered by user ID.

Practice This Problem

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