avg

Calculates the arithmetic mean.

Syntax

Arguments

• x — input values, must be Integer, Float, or Decimal.

Returned value

• The arithmetic mean, always as Float64.
• NaN if the input parameter x is empty.

Example

Query:

Result:

Example

Create a temp table:

Query:

Get the arithmetic mean:

Query:

Result: