AVERAGE Function

The AVG() function returns the average value of a numeric column.

Syntax:

SELECT AVG(column_name)
FROM table_name
WHERE condition;

Query:

SELECT AVG(salary) FROM `salaries`

Output:

Tester Usage Tips:

• Validate reporting average filter criteria’s