SQL запрос яндекс практикум

Question

- Ученик (95), на голосовании 12 месяцев назад

Отберите три зоны первого подключения (поле connection_area) из таблицы buyer, где средняя скидка (поле percent_of_discount) была выше всего.

Answer 1

SELECT connection_area,
AVG(percent_of_discount)
FROM buyer
GROUP BY connection_area
ORDER BY AVG(percent_of_discount) DESC
LIMIT 3

Answer 2

SELECT
connection_area,
AVG(percent_of_discount) AS discount_AVG
FROM buyer
GROUP BY connection_area
ORDER BY discount_AVG DESC
LIMIT 3

Answer 3

SELECT
connection_area,
AVG(percent_of_discount) as avg_discount
FROM buyer
GROUP BY connection_area
ORDER BY AVG(percent_of_discount) DESC
LIMIT 3