Aggregate Functions

COUNT

Returns the number of rows matching the query criteria

SELECT COUNT(*) FROM Employee

AVG

Returns the average of rows matching the query criteria

SELECT locationCode, AVG(maxHours) FROM Employee GROUP By locationCode

MIN

Returns the minimum number of rows matching the query criteria

SELECT MIN(maxHours) FROM Employee

MAX

Returns the maximum number of rows matching the query criteria

SELECT MAX(maxHours) FROM Employee

SUM

Returns the total sum of rows matching the query criteria

SELECT SUM(maxHours) FROM Employee