Top Driver Earnings Per Hour | Dataford Interview Questions

Your question is Top Driver Earnings Per Hour. Start with the requirements and the two tables on the right.

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

Problem

RideNow wants to identify its highest-efficiency drivers based on earnings per hour in the previous calendar month. Write a SQL query to return the drivers whose earnings per hour place them in the top 10% for that period.

Requirements

Use only trips that were completed in the previous calendar month.
For each driver, calculate:
- total earnings as the sum of fare_amount
- total hours worked as the sum of trip duration in hours
- earnings per hour = total earnings / total hours worked
Exclude drivers whose total worked hours are 0 or NULL.
Return only drivers in the top 10% by earnings per hour using a ranking or percentile approach.
Output driver_id, driver_name, total_earnings, total_hours, and earnings_per_hour, ordered by earnings_per_hour descending.

Schema

drivers

Column	Type	Description
driver_idPK	INT	Unique identifier for each driver
driver_name	VARCHAR(100)	Driver full name
city	VARCHAR(50)	Driver's primary city
active_status	VARCHAR(20)	Current status of the driver

trips

Column	Type	Description
trip_idPK	INT	Unique identifier for each trip
driver_id	INT	Driver assigned to the trip
trip_status	VARCHAR(20)	Trip completion status
started_at	TIMESTAMP	Trip start timestamp
ended_at	TIMESTAMP	Trip end timestamp
fare_amount	DECIMAL(10,2)	Fare earned from the trip