SQL Server aggregate functions perform a calculation on a set of values and return a single value. With the exception of the COUNT aggregate function, all other aggregate functions ignore NULL values.
Aggregate functions are frequently used with the GROUP BY clause of the SELECT statement.