Company SQL Question

Completed Trips Count

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

Problem Statement

Find the total number of completed trips for each rider. Show rider name (combined first and last name) and their completed trip count. Only include riders with at least 1 completed trip.

Relevant Tables

riderstrips

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