Question 9541 – SQL

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

Correct Answer: D

Question 15 Explanation:

Group by (avg(salary) > (select avg (salary) from employee))
This results the employees who having the salary more than the average salary.
Sex = M
Selects the Male employees whose salary is more than the average salary in the company.

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 the same department

the average salary of male employees is more than the average salary in the company