Rank Destinations by Monthly Bookings | Dataford Interview Questions

Write a SQL query using window functions to rank destinations by monthly bookings at Expedia Group.

Use confirmed bookings with a non-null booking date, and exclude bookings whose destination does not exist in the destination table.

Output

One row per destination and calendar month, with booking_month, destination_name, monthly_bookings, and booking_rank.
Rank destinations within each month by bookings descending, with ties sharing a rank.
Order by month ascending, rank ascending, and destination name ascending.

bookings

Column	Type	Description
booking_idPK	INT	Unique booking identifier
destination_id	INT	Referenced destination identifier
booking_date	DATE	Date on which the booking was made
booking_status	VARCHAR(20)	Booking lifecycle status

destinations

Column	Type	Description
destination_idPK	INT	Unique destination identifier
destination_name	VARCHAR(100)	Display name of the destination

Your question is Rank Destinations by Monthly Bookings. 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.