Wine Bar: Bookings Without Confirmation

Wine Bar: Bookings Without Confirmation

You are an analyst at the Vinoteka wine bar chain. The evening before service the host sends guests a confirmation request, and the answer lands in the booking card: the guest confirmed, the guest declined, or there is no answer at all yet (the field then stays empty). The manager wants to free up tables for the waiting list and asks for a working list of every booking that CANNOT be treated as confirmed: both explicit declines and the silence — to him both mean a free table. Confirmed bookings must not appear in the list. Return columns: - booking_id — booking identifier; - guest_name — guest name; - restaurant — the venue the booking is for; - booking_date — booking date as a date; - party_size — number of guests. Sort by booking_date ascending, ties by booking_id ascending.

Expected output sample

This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables. Your answer must use the same column names as this sample — alias them with AS if needed.

booking_idguest_namerestaurantbooking_dateparty_size
5Elin DahlVinoteka Old Town2026-03-013
13Ines DuarteVinoteka Riverside2026-03-012
2Pavel NovakVinoteka Old Town2026-03-022
PostgreSQLv16

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid