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
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