company sql set
Uber
Uber
Uber
SQL Set
Trips, drivers, riders, locations, cancellations, surge pricing, retention, and ETA metrics.
question list
Work through all 10 questions
Open a problem, write the query, check the expected output, then come back for the next rep.
Q01
Trip Completion Rate
Calculate completion rate by city.
Q02
Surge Pricing Detection
Compare hourly average fares.
Q03
Driver Utilization Rate
Compute utilization per driver.
Q04
Frequent Riders
Find riders with heavy daily usage.
Q05
Driver Earnings Ranking
Rank drivers within each city.
Q06
Cancellation Rate by Rider
Find riders above a cancellation threshold.
Q07
Most Popular Pickup Location
Identify the most common pickup point.
Q08
Trip Distance Bucketing
Bucket trips by distance.
Q09
Driver Retention
Find drivers active across months.
Q10
Average ETA by City
Average estimated arrival by city.