On this page

    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