ISRO2015-23

Question

Consider the following schema:

$\textsf{Emp (Empcode, Name, Sex, Salary, Deptt)}$

A simple SQL query is executed as follows:

SELECT Deptt FROM Emp
GROUP by Dept
Having avg (Salary) > {select avg (Salary) from Emp}

The output will be

• A. Average salary of male employee is the average salary of the organization
• B. Average salary of male employee is less than the average salary of the organization
• C. Average salary of male employee is equal to the average salary of the organization
• D. Average salary of male employee is more than the average salary of the organization

Comments

select deptName  from Employee  
where sex = 'Male'  \\ $ \color{Red}{Line \ is \ missing \ in \ question}!$
group by deptName 
having avg (salary) >   (select avg (salary) from Employee)

---

I guess the question setter doesn't know English properly..! :)

Isro SQL questions are more based on verbal than dbms..

PEACE

---

@go_editor please correct this question..

Answer 1

Answer : D

Average salary of male employee is more than the average salary of the organization

select deptName 
from Employee 
where sex = 'Male'
group by deptName
having avg (salary) >   
(select avg (salary) from Employee)

Here we are going to get the name of all departments in which the average salary of male employees is greater than the average salary of all employees in the company.