Consider the following schema: Employee(name, sex, salary, deptName). Consider the query SELECT deptName FROM Employee WHERE sex = 'M' GROUP BY deptName HAVING avg(Salary) > (select avg(Salary) from Emp). The output will be
- A. Average salary of male employee is the average salary of the organization
- B. Average salary of male employee is less than the average salary of the organization
- C. Average salary of male employee is equal to the average salary of the organization
- D. Average salary of male employee is more than the average salary of the organization
Answer: D. Average salary of male employee is more than the average salary of the organization
Explanation: It returns departments where the average salary of Male employees is greater than the overall average salary.