MCQOPTIONS
Saved Bookmarks
| 1. |
The employee information of an Organization is stored in the relation:Employee (name, sex, salary, deptname)Consider the following SQL querySelect deptname from Employee Where sex = ‘M’ group by deptname having avg (salary) > {select avg (salary) from Employee}Output of the given query corresponds to |
| A. | Average salary of employee more than average salary of the organization. |
| B. | Average salary less than average salary of the organization. |
| C. | Average salary of employee equal to average salary of the organization. |
| D. | Average salary of male employees in a department is more than average salary of the organization. |
| Answer» E. | |