Consider the following schema:
Emp (Empcode, Name, Sex, Salary, Deptt)
A simple SQL query is executed as follows :
SELECT Deptt FROM Emp
WHERE sex = ‘M’
GROUP by Dept
Having avg (Salary) > { select avg (Salary) from Emp}
The output will be
1
Average salary of male employee is the average salary of the organization
2
Average salary of male employee is less than the average salary of the organization
3
Average salary of male employee is equal to the average salary of the organization
4
Average salary of male employees is more than the average salary of the organization
5
Question Not Attempted