1.

The employee information in a company is stored in the relationEmployee (name, sex, salary, deptName)(name is primary key )Consider the following SQL queryselect 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
Answer» E.


Discussion

No Comment Found