UBER & RIDE-SHARING CASE STUDY

Step 5: SQL Queries & Use Cases (Uber)

Banner

1. Calculate Monthly Earnings for a Driver

Retrieves completed trips and tallies up payments:

SELECT d.driver_id, d.first_name, d.last_name,
       SUM(p.amount) AS total_earnings,
       COUNT(t.trip_id) AS total_trips
FROM drivers d
JOIN trips t ON d.driver_id = t.driver_id
JOIN payments p ON t.trip_id = p.trip_id
WHERE t.status = 'completed' 
  AND p.status = 'completed'
  AND t.requested_at >= '2026-05-01'
GROUP BY d.driver_id;

2. Find High-Rating In-Progress Rides

SELECT t.trip_id, r.first_name AS rider_name, d.first_name AS driver_name
FROM trips t
JOIN riders r ON t.rider_id = r.rider_id
JOIN drivers d ON t.driver_id = d.driver_id
WHERE t.status = 'in_progress' AND d.rating >= 4.8;

lock

This content is reserved for Premium Members.

Upgrade to Premium