Categories: Aggregate

AVG

Computes the average of a set of values.

Syntax

AVG(numeric_expression NUMERIC) → FLOAT

  • numeric_expression: DOUBLE, FLOAT, INTEGER, INTERVAL_DATE, INTERVAL_YEAR

Examples

SELECT AVG(3)
-- 3.0
SELECT AVG("val")
-- -0.333333