Database Analyst Question:

Aggregate functions perform calculations on a set of values and return a single value. The common aggregate functions are:

☛ COUNT (counts the number of rows in the table)
☛ SUM (returns the sum of all values of a numeric column)
☛ AVG (returns the average of all values of a numeric column)
☛ MIN (returns the lowest value of a numeric column)
☛ MAX (returns the highest value of a numeric column).

Aggregate functions are frequently used in combination with the GROUP BY statement.