Top Cities by Ride Growth | Dataford Interview Questions

SwiftRide wants to identify which cities are growing fastest in completed rides month over month. Write a SQL query to return the top cities by ride growth rate for each month.

Requirements

Count completed rides per city per month.
Compare each city-month to the previous month for the same city.
Calculate growth rate as (current_month_rides - previous_month_rides) / previous_month_rides * 100.
Return only months where the previous month exists and previous month rides are greater than 0.
For each month, rank cities by growth rate descending and return the top 2 cities.

Schema

cities

Column	Type	Description
city_idPK	INT	Unique city identifier
city_name	VARCHAR(100)	City name
region	VARCHAR(50)	Operating region for the city

drivers

Column	Type	Description
driver_idPK	INT	Unique driver identifier
city_id	INT	Driver's assigned city
driver_name	VARCHAR(100)	Driver full name
status	VARCHAR(20)	Driver status such as active or inactive

rides

Column	Type	Description
ride_idPK	INT	Unique ride identifier
driver_id	INT	Driver associated with the ride
rider_id	INT	Rider identifier
ride_date	DATE	Date the ride occurred
ride_status	VARCHAR(20)	Ride status such as completed or cancelled
fare_amount	NUMERIC(10,2)	Fare charged for the ride

Your question is Top Cities by Ride Growth. 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