MySQL SQL

MySQL Aggregate Functions

Calculate one result from many rows.

Aggregate data

SELECT category, COUNT(*) AS product_count,
       AVG(price) AS average_price
FROM products
GROUP BY category;

Common aggregate functions include MIN, MAX, COUNT, SUM, and AVG.