/
Russid
/
python_advanced
Обзор
Документация
Войти
/
Russid
/
python_advanced
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
module_19_db4/materials/data_agregation.sql
49 строк
760 B
Andrei Shulaev
add sql queris to materials
11 июл 2021, 23:08
11 июл 2021, 23:08
8d64c53
Код
Авторство
О чём код?
SELECT DISTINCT city FROM customer; SELECT DISTINCT city, full_name FROM customer; SELECT count(*) FROM orders; SELECT count(*) FROM orders WHERE purchase_amount > 800 AND purchase_amount < 900; SELECT avg(purchase_amount) FROM orders; SELECT round(avg(purchase_amount)) AS averege_purchase_amount FROM orders; SELECT sum(purchase_amount) AS total_amount FROM orders; SELECT max(purchase_amount) AS max_purchase FROM orders; SELECT max(purchase_amount) AS max_purchase, m.full_name FROM orders o INNER JOIN manager m ON m.manager_id = o.manager_id; SELECT min(purchase_amount) AS max_purchase, m.full_name FROM orders o INNER JOIN manager m ON m.manager_id = o.manager_id; SELECT sum(full_name) FROM manager;