Function

Description

Example

AVG

Returns the average value of a numeric column / expression

SELECT AVG(commission_rate)

FROM sales_rep_tbl

COUNT

Returns the number of rows (without a NULL value) of a column / expression

SELECT COUNT(FirstName)

FROM employee

COUNT(*)

Returns the number of selected rows

SELECT COUNT(*)

FROM employee

MAX

Returns the highest value of a numeric or character column / expression

SELECT MAX(commission_rate)

FROM sales_rep_tbl

MIN

Returns the lowest value of a numeric or character column

SELECT MIN(FirstName)

FROM employee

SUM

Returns the total sum of a column

SELECT SUM(ytd_sales)

FROM sales_rep_tbl