AVG
Function AVG is also found in the following categories: Window functions.
Syntax
Standard
Extended
AVG( value )
AVG( value
[ FIXED ... | INCLUDE ... | EXCLUDE ... ]
[ BEFORE FILTER BY ... ]
)
More info:
Description
Returns the average of all values. Applicable to numeric data types as well as Date.
Argument types:
value—Date | Datetime | Fractional number | Integer
Return type: Depends on argument types
Example
AVG([Profit])
Data source support
ClickHouse 19.13, Microsoft SQL Server 2017 (14.0), MySQL 5.6, PostgreSQL 9.3.