Consider the following schema:
Emp (Empcode, Name, Sex, Salary, Deptt)
A simple SQL query is executedasfollows:
SELECT Deptt FROM Emp
WHEREsex = ‘M’
GROUP by Dept
Having avg (Salary) > { select avg (Salary) from Emp}
The output will be

A

Average salary of male employeeis the average salary of the organization

B

Average salary of male employeeis 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 employees is more than the average salary of the organization