Find Restaurants With Zero Bookings | Dataford Interview Questions

Given two tables, one with restaurant details and one with daily reservation logs, write a query to identify restaurants that have had zero bookings in the past week at OpenTable.

For this exercise, define the past week as February 10, 2025 through February 16, 2025, inclusive.

Output

Return one row per restaurant with restaurant_id, restaurant_name, and bookings_last_7_days.
Include restaurants with no reservation-log rows or only zero or NULL booking counts during the period, and exclude restaurants with positive bookings.
Order by restaurant_id ascending.

Schema

restaurants

Column	Type	Description
restaurant_idPK	INT	Unique identifier for the restaurant
restaurant_name	VARCHAR(150)	Display name of the restaurant
city	VARCHAR(100)	Restaurant city

daily_reservation_logs

Column	Type	Description
log_idPK	INT	Unique identifier for the daily log row
restaurant_id	INT	Restaurant associated with the log
reservation_date	DATE	Date represented by the log
booking_count	INT	Number of bookings recorded for the restaurant on that date

Your question is Find Restaurants With Zero Bookings. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem