Aggregate functions

Calculate values across multiple rows. COUNT, SUM, AVG, MIN, MAX.

query.sql

SELECT COUNT(*) FROM users;

SELECT 
  SUM(total) AS revenue,
  AVG(total) AS avg_order,
  MAX(total) AS biggest
FROM orders;

🧮

Crunch numbers across rows