avg.md

description
Computes the average of a set of values.

AVG

Syntax

AVG(numeric_expression NUMERIC) → FLOAT

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

Examples

{% code title="AVG example" %}

SELECT AVG(3)
-- 3.0

{% endcode %}

{% code title="AVG example" %}

SELECT AVG("val")
-- -0.333333

{% endcode %}

\