Users Also Read
MCQ's Search Engine
Electrical Engineering
Mechanical Engineering
Civil Engineering
Automobile Engineering
Chemical Engineering
Computer Engineering
Electronics Engineering
Medical Science Engg
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 | |
A. | Average salary of employee more than average salary of the organization. [Wrong Answer] |
B. | Average salary of male employees in a department is more than average salary of the organization [Correct Answer] |
C. | Average salary of employee equal to average salary of the organization [Wrong Answer] |
D. | Average salary less than average salary of the organization. [Wrong Answer] |