Restaurants with a high average order

Easy

Question

A food delivery app wants to find its premium restaurants.

Look only at orders with status delivered. A restaurant is premium when the average amount of its delivered orders is MORE than 300 rupees.

Return restaurant (the name), delivered_orders (how many delivered orders it has) and avg_amount (the average, rounded to 2 decimals). The order of the rows does not matter.

group by
having
avg
round

Read first: Lesson 45, SQL groups: GROUP BY, HAVING and conditional counts

Tables

2 tables

These are the example rows. Run uses only these rows. Submit also tests your query on a second set of rows that you cannot see.

restaurants3 columns · 5 rowsnot run yet

CREATE TABLE restaurants (id INTEGER PRIMARY KEY, name TEXT NOT NULL, city TEXT NOT NULL);

Example rows of the restaurants table
id	name	city
1	Spice Route	Mumbai
2	Dosa Corner	Chennai
3	Tandoor House	Delhi
4	Biryani Bay	Hyderabad
5	Chaat Stop	Kolkata

food_orders5 columns · 16 rowsnot run yet

CREATE TABLE food_orders (id INTEGER PRIMARY KEY, restaurant_id INTEGER NOT NULL REFERENCES restaurants(id), status TEXT NOT NULL, amount INTEGER NOT NULL, ordered_at TEXT NOT NULL);

Example rows of the food_orders table
id	restaurant_id	status	amount	ordered_at
1	1	delivered	450	2026-03-01
2	1	delivered	380	2026-03-02
3	1	delivered	411	2026-03-04
4	1	cancelled	900	2026-03-05
5	2	delivered	220	2026-03-02
6	2	delivered	190	2026-03-03
7	2	cancelled	150	2026-03-04
8	3	delivered	250	2026-03-03
9	3	delivered	350	2026-03-04
10	3	cancelled	1000	2026-03-06
11	4	delivered	560	2026-03-04
12	4	delivered	610	2026-03-05
13	4	delivered	480	2026-03-06
14	4	delivered	205	2026-03-07
15	5	delivered	700	2026-03-06
16	5	cancelled	50	2026-03-07

About this SQL

WHERE filters rows before they are grouped, HAVING filters the groups after. AVG of whole numbers returns a decimal number in SQLite (it is not integer division). ROUND(x, 2) rounds to 2 decimals, and a half is rounded away from zero (2.5 becomes 3).

SQLite

Opening the code editor…

Result

Run shows what your query gives on the example rows.Submit checks it on the example rows and on a hidden set of rows.

SQL · ready