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.
A ordem das linhas importa
Entre para ver seu histórico de envios
EntrarEntre para usar o AI Mentor
Entrar