Question-39

DBMS

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