Rank Providers by Monthly Volume | Dataford Interview Questions

Write a query using window functions to rank healthcare providers based on their monthly booking volume within each geographic region for Zocdoc.

Use completed bookings from January and February 2025. Rows associated with a provider whose region is NULL must be ignored.

Output

One row per provider, region, and month with completed bookings.
Columns: region, booking_month, provider_id, provider_name, booking_volume, and regional_rank.
Ties share the same rank. Sort by region, month, rank, and provider ID.

providers

Column	Type	Description
provider_idPK	INT	Unique healthcare provider identifier
provider_name	VARCHAR(100)	Provider display name
region	VARCHAR(50)	Geographic region for the provider

bookings

Column	Type	Description
booking_idPK	INT	Unique booking identifier
provider_id	INT	Referenced healthcare provider
booked_at	TIMESTAMP	Timestamp when the booking was created
status	VARCHAR(50)	Booking lifecycle status

Your question is Rank Providers by Monthly Volume. 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.