Basic←→0 / 70

Above average

#060BasicSubqueriesAggregates4 min

The shop wants to see which things cost more than average. Pick the products whose price is above the average price of all products, with name and price. Work the average out with a query; don't type it in.

The tables

products

id	name	category	price	stock
1	Milk tea	drink	12	30
2	Lemon water	drink	8	50
3	Cheesecake	cake	25	6
4	Cookie	snack	5	80
5	Brownie	cake	18	0
6	Iced coffee	drink	15	20
7	Chips	snack	7	40
8	Fruit tart	cake	28	4

8 rows

query.sql

SELECT name, price
FROM products
WHERE price > (
  -- your code here: inside the brackets, a query that works out AVG(price)
);

Ctrl + Enter runs too

Result

Run shows what your query gives. When it looks right, Submit.