Compare Driver Hourly Earnings by Zone

EasySQL · PostgreSQL00:00

Practice interviewer

In session

5 left

00:00

Your question is Compare Driver Hourly Earnings by Zone. Start with the requirements and the one table 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.

You need to log in / sign up to run or submit.

Problem

RideNow wants a simple comparison of driver pay efficiency across service areas. Write a SQL query to calculate the average earnings per hour for rides in the Downtown zone versus the Suburbs zone.

Requirements

Use only rows where zone is Downtown or Suburbs.
For each zone, calculate average earnings per hour as SUM(earnings) / SUM(ride_minutes / 60.0).
Exclude rows where ride_minutes is NULL or less than or equal to 0.
Return zone and avg_earnings_per_hour, ordered by avg_earnings_per_hour descending.

Schema

driver_rides

Column	Type	Description
ride_idPK	INT	Unique ride identifier
driver_id	INT	Driver identifier
zone	VARCHAR(50)	Service zone where the ride occurred
ride_minutes	INT	Ride duration in minutes
earnings	DECIMAL(10,2)	Driver earnings for the ride
ride_date	DATE	Date of the ride

Tablesdriver_rides

Your solutionPostgreSQL

You need to log in / sign up to run or submit.

Run a query to see results