SQL for Weekly Driver Earnings | Dataford Interview Questions

Write a SQL query to find the average weekly earnings of drivers who completed their first trip in the last 30 days, grouped by city at Uber Drivers.

Use CURRENT_DATE as the reference date. Treat a driver's first trip as their earliest completed trip, and calculate the average from recorded weekly earnings for eligible drivers.

Output

One row per city, including cities with eligible drivers but no recorded earnings
Columns: city, average_weekly_earnings
Exclude drivers whose earliest completed trip is outside the last 30 days
Sort by city ascending, with NULL cities last

Schema

drivers

Column	Type	Description
driver_idPK	INT	Unique Uber Drivers driver identifier
city	VARCHAR(100)	City associated with the driver

trips

Column	Type	Description
trip_idPK	INT	Unique trip identifier
driver_id	INT	Driver who completed or attempted the trip
trip_date	DATE	Date of the trip
status	VARCHAR(20)	Trip status

weekly_earnings

Column	Type	Description
earning_idPK	INT	Unique weekly earnings record identifier
driver_id	INT	Driver associated with the earnings record
week_start	DATE	Start date of the earnings week
weekly_earnings	DECIMAL(10,2)	Recorded earnings for the week

Your question is SQL for Weekly Driver Earnings. Start with the requirements and the three tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem