Top 3 Revenue Bookings | Dataford Interview Questions

Marriott International wants a monthly view of its highest-value bookings across Marriott properties. Write a PostgreSQL query that ranks eligible bookings by revenue within each calendar month.

Requirements

Join marriott_bookings to marriott_properties to include the property name.
Exclude cancelled bookings, bookings without revenue, and bookings whose property is not present in the property table.
Return the top three bookings per month, ordered by revenue descending within each month. Use booking_id as a deterministic tie-breaker.

Schema

marriott_properties

Column	Type	Description
property_idPK	INTEGER	Unique Marriott property identifier
property_name	VARCHAR(120)	Displayed Marriott property name
city	VARCHAR(80)	City where the property is located
brand	VARCHAR(60)	Marriott brand associated with the property

marriott_bookings

Column	Type	Description
booking_idPK	INTEGER	Unique booking identifier
property_id	INTEGER	Referenced Marriott property identifier
check_in_date	DATE	Guest arrival date
booking_status	VARCHAR(20)	Current status of the booking
total_revenue	NUMERIC(12,2)	Total booking revenue in U.S. dollars

Your question is Top 3 Revenue 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.

Problem