AVG
Returns the average value of a numeric column.
Analyze Syntax
func.avg(get_column(table, 'salary'))
Analyze Examples
func.avg(get_column(table, 'salary'))
SQL Syntax
AVG(<salary>)
SQL Examples
SELECT department, AVG(salary) FROM employees GROUP BY department;
┌────────────┬──────────────┐
│ department │ avg(salary) │
├────────────┼──────────────┤
│ Sales │ 65000.00 │
│ IT │ 82000.00 │
└────────────┴──────────────┘