Skip to main content
Version: 0.0.1

AVG

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

{{< codeheader "AVG example" >}}

SELECT AVG(3)
-- 3.0

{{< codeheader "AVG example" >}}

SELECT AVG("val")
-- -0.333333