/
mialdr
/
python_advanced
Обзор
Документация
Войти
/
mialdr
/
python_advanced
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
module_19_db4/materials/data_agregation.sql
49 строк
760 B
Mikhail
added files
03 мар 2024, 10:02
03 мар 2024, 10:02
99f6bc9
Код
Авторство
О чём код?
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;