Docs›Reference›Functions›Aggregate›avgavgOn this pageSyntaxArguments<expr>Returns the average of non-NULL records. If all records inside a group are NULL, the function returns NULL. Syntax Copyavg( <expr> ) Arguments <expr> This is an expression that evaluates to a numeric data type.