Top Restaurants by Order Frequency | Dataford Interview Questions

Write a SQL query to extract the top 10 restaurants by order frequency in a specific region.

Use the provided restaurant and order data, filtering for the region London. Treat each row in orders as one order. Return restaurants with the highest number of orders first, using restaurant ID as the tie-breaker.

Output

One row per restaurant included in the top 10.
Columns: restaurant_id, restaurant_name, and order_frequency.
Include only London restaurants, ordered by order_frequency descending and restaurant_id ascending for ties.

Schema

restaurants

Column	Type	Description
restaurant_idPK	INT	Unique restaurant identifier
restaurant_name	VARCHAR(100)	Restaurant display name
region	VARCHAR(50)	Geographic region where the restaurant operates

orders

Column	Type	Description
order_idPK	INT	Unique order identifier
restaurant_id	INT	Restaurant associated with the order
order_status	VARCHAR(30)	Current order status

Your question is Top Restaurants by Order Frequency. 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