SQL · Uber · Medium
Assume the current date is 2025-09-01. You are given the following relational schema and a small set of illustrative rows. Tables: riders(rider_id, name, signup_date) drivers(driver_id, name, car_year) trips(trip_id, rider_id, driver_id, request_time, pickup_time, dropoff_time, status, city, surge_multiplier, distance_km, fare_usd) status is one of 'completed', 'cancelled_by_rider', 'cancelled_by_driver', 'driver_no_show' payments(trip_id, amount_usd, method, card_hash,…
Checking your access…