GROUP BY and HAVING

Aggregate functions take multiple inputs and provide a single output. The most common are: AVG() which returns the average value SELECT AVG(column_name) FROM table_name COUNT() which returns the number of values SELECT COUNT(*) FROM table_name MAX(...