08-02 AVG

01

Find average of employee salaries

SELECT AVG(salary)
from employee;

02

Find average salaray of male employees

SELECT AVG(salary)
from employee
where sex = 'M';