Aggregate Functions
Find SUM, AVG, MAX, MIN, COUNT statistics for multiple rows.
Several rows map into one “statistics” row
Can use WHERE clauses to specify rows
Be careful of NULL’s COUNT(Salary) only counts non-Nulls AVG(Salary) doesn’t include Null vals