SQL Aggregate Functions SQL Tutorial
The following are the commonly used SQL aggregate functions: AVG () returns the average of a set. COUNT () returns the number of items in a set. MAX () returns the maximum value in a set. MIN () returns the minimum value in a set SUM () returns the sum of all or distinct values in a set