COUNT, SUM, AVG, MIN, MAX, STDDEV, and VARIANCE — collapse multiple rows into single summary values. COUNT(*) counts rows; COUNT(column) counts non-NULL values; COUNT(DISTINCT column) counts unique non-NULL values.