Returns the average of the values in a group. Null values are ignored.
Syntax:
AVG ( expression )
Example:
SELECT AVG(VacationTime)AS 'Average vacation time in hours', SUM(SickLeave) AS 'Total sick leave time in hours' FROM HR.Employee WHERE JobTitle LIKE 'Vice Admiral%' |
|---|