Course Process
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