SQL Practice Logo

SQLPractice Online

Company SQL Question

Rider Retention Analysis

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

Problem Statement

Calculate inter-trip gap days per rider using LAG() window function and two CTEs.

Relevant Tables

tripsriders

SQL Concepts Used in This Question

Strengthen your understanding with these targeted learning topics: