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_idguest_namerestaurantbooking_dateparty_size
5Elin DahlVinoteka Old Town2026-03-013
13Ines DuarteVinoteka Riverside2026-03-012
2Pavel NovakVinoteka Old Town2026-03-022
PostgreSQLv16
Entre para enviar

O resultado da sua consulta aparecerá aqui

Focus radio
Paused · SomaFM · Fluid