Consider the following schema:
$\textsf{Emp (Empcode, Name, Sex, Salary, Deptt)}$
A simple SQL query is executed as follows:
SELECT Deptt FROM Emp
GROUP by Dept
Having avg (Salary) > {select avg (Salary) from Emp}
The output will be
- Average salary of male employee is the average salary of the organization
- Average salary of male employee is less than the average salary of the organization
- Average salary of male employee is equal to the average salary of the organization
- Average salary of male employee is more than the average salary of the organization