

MCQOPTIONS
Saved Bookmarks
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. | |