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_id | guest_name | restaurant | booking_date | party_size |
|---|---|---|---|---|
| 5 | Elin Dahl | Vinoteka Old Town | 2026-03-01 | 3 |
| 13 | Ines Duarte | Vinoteka Riverside | 2026-03-01 | 2 |
| 2 | Pavel Novak | Vinoteka Old Town | 2026-03-02 | 2 |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign in