UGC NET CSE | June 2013 | Part 3 | Question: 8

Question

The employee information of an organization is stored in a relation: Employee (name, sex, salary, deptname). Consider the following SQL query:

Select deptname from Employee where sex=’M’ group by dept name 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 of employee 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 1

Answer : D

Select deptname

it says we are selecting Department.

from Employee

Both above put together says we are selecting Dept name just by considering employee Table

where sex=’M’

It says we are selecting Male Employee.

 group by dept name having 
avg (salary) 

it says we are grouping all the male employee in a Department whose avg salary is something

> {select avg (salary) from Employee}

This Last Comparison says we have selected something which is greater then the right side of comparison Operator

So What we have selected is

Average salary of male employees in a department is more than average salary of the organization

Comments

Good Explanation   

Answer 2

Option(D).Average salary of male employees in a department is more than average salary of the organization