The employee information of an Organization 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}
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.
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}
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.