City Ride Demand SQL Analysis | Dataford Interview Questions

Write a SQL query to analyze city-level ride demand, driver supply, and conversion trends over time for Didi Chuxing.

Use the cities, ride_requests, and driver_sessions tables. Report monthly metrics for the available reporting period, excluding requests without a valid city.

Output

One row per city and month with ride requests, completed rides, active drivers, and conversion rate.
Columns: city_name, month, ride_requests, completed_rides, active_drivers, conversion_rate.
Sort by city_name, then month ascending.

Schema

cities

Column	Type	Description
city_idPK	INT	Unique city identifier
city_name	VARCHAR(100)	Didi service city name

ride_requests

Column	Type	Description
request_idPK	INT	Unique ride request identifier
city_id	INT	Requested pickup city
requested_at	TIMESTAMP	Timestamp when the ride was requested
status	VARCHAR(20)	Ride outcome, such as completed or cancelled

driver_sessions

Column	Type	Description
session_idPK	INT	Unique driver session identifier
city_id	INT	City where the driver was available
driver_id	INT	Driver identifier
session_date	DATE	Date of the driver session
online_minutes	INT	Minutes the driver was online

Your question is City Ride Demand SQL Analysis. 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