SELECT category_name, AVG(price)
FROM category c JOIN product p ON c.category_id = p.category_id
GROUP BY category_name HAVING AVG(price) > 200;
Схема БД и код для генерации данных
находятся в шапке канала
SQ SQL Pro @sqlprofi · 4.91K subscribers SELECT category_name, AVG(price)
FROM category c JOIN product p ON c.category_id = p.category_id
GROUP BY category_name HAVING AVG(price) > 200;