The employee information in a company is stored in the relation
- Employee (name, sex, salary, deptName)
Consider the following SQL query
Select deptName
From Employee
Where sex = ‘M’
Group by deptName
Having avg(salary) >
(select avg (salary) from Employee)
It returns the names of the department in which
the average salary is more than the average salary in the company
the average salary of male employees is more than the average salary of all male employees in the company
the average salary of male employees is more than the average salary of employees in same the department
the average salary of male employees is more than the average salary in the company