Skip to content
Related Articles

Related Articles

GATE | GATE CS 2021 | Set 2 | Question 41

Improve Article
Save Article
Like Article
  • Last Updated : 18 Oct, 2021

The relation scheme given below is used to store information about the employees of a company, where empId is the key and deptId indicates the department to which the employee is assigned. Each employee is assigned to exactly one department.

emp(empId, name, gender, salary, deptId) 

Consider the following SQL query:

select deptId, count(*)
from emp
where gender = “female” and salary > (select avg(salary)from emp)
group by deptId; 

The above query gives, for each department in the company, the number of female employees whose salary is greater than the average salary of
(A) employees in the department
(B) employees in the company
(C) female employees in the department
(D) female employees in the company


Answer: (B)

Explanation: Inner query : (select avg(salary) from emp) runs on whole of the emp table mentioned hence on all employees.

So, option (B) is correct.

Quiz of this Question

My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!