/
Russid
/
python_advanced
Обзор
Документация
Войти
/
Russid
/
python_advanced
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
module_19_db4/materials/group_by.sql
61 строка
1 KB
Andrei Shulaev
add materials to module 19
11 июл 2021, 23:05
11 июл 2021, 23:05
a13bdbb
Код
Авторство
О чём код?
SELECT sum(purchase_amount), manager_id FROM orders GROUP BY manager_id; SELECT sum(purchase_amount), full_name FROM orders LEFT OUTER JOIN manager m ON m.manager_id = orders.manager_id GROUP BY orders.manager_id; SELECT sum(purchase_amount), full_name FROM orders LEFT OUTER JOIN manager m ON m.manager_id = orders.manager_id GROUP BY orders.manager_id; SELECT avg(purchase_amount), full_name FROM orders LEFT OUTER JOIN manager m ON m.manager_id = orders.manager_id GROUP BY orders.manager_id; SELECT purchase_amount, manager_id FROM orders GROUP BY manager_id, purchase_amount SELECT city, avg(purchase_amount) avg_purchase FROM customer INNER JOIN orders o ON customer.customer_id = o.customer_id GROUP BY city ORDER BY avg_purchase DESC; SELECT full_name, count(purchase_amount) AS cnt_purchases FROM orders INNER JOIN manager m ON m.manager_id = orders.manager_id GROUP BY full_name HAVING cnt_purchases > 500; SELECT full_name, count(purchase_amount) AS cnt_purchases FROM orders INNER JOIN manager m ON m.manager_id = orders.manager_id GROUP BY full_name HAVING full_name like 'Пет%'; SELECT full_name, count(purchase_amount) AS cnt_purchases FROM orders INNER JOIN manager m ON m.manager_id = orders.manager_id WHERE full_name like 'Пет%' GROUP BY full_name