Running Bookings by Brand | Dataford Interview Questions

How would you use a window function to calculate the running total of bookings per day for a specific hotel brand on Expedia Group?

Write a PostgreSQL query for the Expedia Collection brand. Include only confirmed bookings and calculate the daily booking count before calculating the cumulative total.

Output

One row per booking date with confirmed bookings for the specified brand
Columns: booking_date, daily_bookings, and running_total
Order by booking_date ascending

Schema

hotels

Column	Type	Description
hotel_idPK	INT	Unique hotel identifier
hotel_name	VARCHAR(150)	Hotel property name
brand_name	VARCHAR(100)	Hotel brand associated with the property

bookings

Column	Type	Description
booking_idPK	INT	Unique booking identifier
hotel_id	INT	Referenced hotel identifier
booking_date	DATE	Date on which the booking was made
status	VARCHAR(20)	Booking status

Your question is Running Bookings by Brand. 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