Q53

MCQ2 marks, −0.5

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

(D)

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

Loading…