SQL: Агрегатные функции и GROUP BY

-- SQL: Агрегатные функции и GROUP BY -- COUNT SELECT COUNT(*) FROM users; SELECT COUNT(DISTINCT category) FROM products; -- SUM, AVG, MIN, MAX SELECT SUM(total) FROM orders; SELECT AVG(price) FROM products; SELECT MIN(price) FROM products; SELECT MAX(price) FROM products; -- GROUP BY SELECT category, COUNT(*) FROM products GROUP BY category; SELECT status, SUM(total) FROM orders GROUP BY status; -- GROUP BY с…