Company SQL Question

Rider Retention Analysis

Practice this Uber style SQL interview question with live execution and instant feedback.

Problem Statement

Calculate the average time gap (in days) between consecutive trips for each rider who has taken at least 2 trips. Show rider name, total trips, and average gap in days.

Relevant Tables

tripsriders

SQL Concepts Used in This Question

Strengthen your understanding with these targeted learning topics:

Window Functions FundamentalsWindow Functions
Running Totals & Moving AveragesWindow Functions
INNER JOIN Deep DiveJoins & Relationships