SQL: Rides and Weekly Drivers | Dataford Interview Questions

A transportation platform needs a weekly operating report for San Francisco. Write a SQL query that returns completed San Francisco rides and active San Francisco-based drivers for each of the 12 calendar weeks ending in the reporting week of 2026-09-06.

Output

Return one row per week and metric, with columns week_start, metric_name, and metric_value.
Include every week in the 12-week period, including weeks with no activity, using zero for missing metrics.
completed_sf_rides counts rides whose region is San Francisco and whose completion flag is Y.
active_sf_drivers counts distinct drivers whose home region is San Francisco and who have at least one ride in that week, regardless of ride completion status.
Order by week_start ascending and then metric_name ascending.

Schema

rides

Column	Type	Description
ride_idPK	INT	Unique ride identifier
start_time	TIMESTAMP	Ride start timestamp
end_time	TIMESTAMP	Ride end timestamp
passenger_id	INT	Passenger identifier
driver_id	INT	Passenger identifier referencing drivers.driver_id
ride_region	VARCHAR(100)	Region where the ride occurred
is_completed	VARCHAR(1)	Whether the ride completed, Y or N

drivers

Column	Type	Description
driver_idPK	INT	Unique driver identifier
onboarding_time	TIMESTAMP	Timestamp when the driver completed onboarding
home_region	VARCHAR(100)	Driver's home region

Your question is SQL: Rides and Weekly Drivers. Start with the requirements and the two 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