SQL: Подзапросы и сложные конструкции

-- SQL: Подзапросы и сложные конструкции -- Подзапрос в WHERE SELECT * FROM users WHERE id IN (SELECT user_id FROM orders WHERE total > 1000); SELECT * FROM products WHERE price > (SELECT AVG(price) FROM products); -- Подзапрос в SELECT SELECT name, (SELECT COUNT(*) FROM orders WHERE orders.user_id = users.id) as order_count FROM users; -- EXISTS и NOT EXISTS SELECT * FROM users WHERE EXISTS (SELECT 1 FROM orders…