Often you need one number from many rows, like the total payroll or the highest salary. COUNT, SUM, AVG, MIN and MAX collapse a column into a single value. Use them for any summary question about the whole table or, with GROUP BY, each group. Watch the NULL rules: COUNT(*) counts rows, while COUNT(column) and AVG skip NULLs.