SUM

Calculates the sum of all expression values.

AVG

Calculates the average of the expression values in a group.

STDEV

Returns the statistical standard deviation of all values in the specified expression.

COUNT

Calculates the number of rows in the query.

COUNT UNIQUE

Returns the number of unique items in a group.

MIN

Returns the minimum value in the expression.

MAX

Returns the maximum value in the expression.

ABS

Returns the absolute (positive) value of the expression.

CEIL

Returns the smallest integer that is greater than or equal to the expression.

FLOOR

Returns the largest integer less than or equal to the expression.

TO DATE

Converts an expression of a compatible data type/format into DATE/DATETIME data type.

SQRT

Extracts the square root from the expression.