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.


Discussion

No Comment Found