Snippet

Computing Column Averages with the AVG Function

The AVG aggregate function calculates the arithmetic mean of non-NULL values across all rows in a numeric column.

snippet.sql

sql

SELECT AVG(salary) AS average_salary FROM employees;

Breakdown

SELECT AVG(salary) AS average_salary FROM employees;

Calculates the mathematical mean of values in the salary column and returns it with the alias average_salary.