Test Index

GATE Computer Science (CS) 2021 Shift 2 Solved Paper

© examsnet.com

Question : 41 of 65

Marks: +1, -0

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(⋆)

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

female employees in the department.
employees in the department.
employees in the company.
female employees in the company.

Go to Question:

Prev Question

Next Question