Name

Example

AVG

SELECT AVG(price) FROM titles

COUNT

SELECT COUNT(*) FROM titles

MAX

SELECT MAX(price) FROM titles

MIN

SELECT MIN(price) FROM titles

SUM

SELECT SUM(price) FROM titles

Must be used with numeric columns only. Null values are ignored.

STDEV, STDDEV        

SELECT STDEV(price) FROM titles

Must be used with numeric columns only. Null values are ignored.

VAR

SELECT VAR(price) FROM titles

Must be used with numeric columns only. Null values are ignored.