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.
Exemplo de resposta esperada
É assim que se parece uma resposta correta: ela tem seu próprio número de linhas e não precisa coincidir com as tabelas do esquema. Sua resposta precisa retornar os mesmos nomes de colunas do exemplo: use AS para renomeá-las se for preciso.
| 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 |
Entre para ver seu histórico de envios
EntrarEntre para usar o AI Mentor
Entrar