Returns the arithmetic average of all values in value_expression.
AVG is valid only for numeric data.
Nulls are not included in the result computation.
This function returns the REAL data type.
To invoke the time series version of this function, use the GROUP BY TIME clause. For more information, see Teradata Vantage™ - Time Series Tables and Operations, B035-1208.
For the AVG window function that computes a group, cumulative, or moving average, see Window Aggregate Functions.