/
mialdr
/
python_advanced
Обзор
Документация
Войти
/
mialdr
/
python_advanced
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
module_19_db4/materials/nested_queries.sql
67 строк
1 KB
Mikhail
added files
03 мар 2024, 10:02
03 мар 2024, 10:02
99f6bc9
Код
Авторство
О чём код?
SELECT count(order_no) FROM orders WHERE manager_id = (SELECT manager_id FROM manager WHERE full_name LIKE 'Семёнов%'); SELECT count(order_no) FROM orders JOIN manager m ON m.manager_id = orders.manager_id WHERE m.full_name like 'Семёнов%'; SELECT full_name FROM manager WHERE city in (SELECT DISTINCT city FROM manager WHERE city != 'Москва' ); SELECT full_name FROM customer WHERE customer_id in (SELECT customer_id FROM orders WHERE purchase_amount > 900 ) SELECT order_no, manager_name, customer_name FROM orders INNER JOIN (SELECT m.full_name AS manager_name, manager_id AS man_id, city AS c_city FROM manager m) ON orders.manager_id = man_id INNER JOIN (SELECT full_name AS customer_name, customer_id AS cus_id, city AS m_city FROM customer c) ON cus_id = orders.customer_id WHERE c_city == m_city; SELECT full_name, date, amount FROM manager INNER JOIN (SELECT date AS date, purchase_amount AS amount, manager_id AS man_id FROM orders) ON manager_id = man_id WHERE amount > 900 ORDER BY date DESC LIMIT 10; SELECT full_name FROM customer WHERE exists (SELECT full_name AS m_name FROM manager WHERE full_name like '%' || substr(full_name, -4) );