The employee information in a company is stored in the relation Employee…

GATE · 2004 · CS

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

A.
the average salary is more than the average salary in the company
B.
the average salary of male employees is more than the average salary of all male employees in the company
C.
the average salary of male employees is more than the average salary of employees in the same department
D.
the average salary of male employees is more than the average salary in the company

Attempted by 359 students.