Monthly Overbooking Signals | Dataford Interview Questions

Write a query to identify passengers who have booked more than three flights in a single month, displaying their names and total bookings.

Use the passengers and flight_bookings tables. Bookings with a NULL booked_at value must be ignored.

Output

One row per passenger and qualifying booking month.
Columns: passenger_name, booking_month, and total_bookings.
Include only passenger-month combinations with more than three bookings. Order by booking_month ascending, then passenger_name ascending.

passengers

Column	Type	Description
passenger_idPK	INTEGER	Unique passenger identifier
passenger_name	VARCHAR(100)	Passenger's full name
loyalty_tier	VARCHAR(30)	MileagePlus loyalty tier

flight_bookings

Column	Type	Description
booking_idPK	INTEGER	Unique booking identifier
passenger_id	INTEGER	Passenger associated with the booking
booked_at	TIMESTAMP	Timestamp when the flight was booked
flight_number	VARCHAR(10)	United Airlines flight number

Your question is Monthly Overbooking Signals. 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.