The relation scheme given below is used to store information about the…

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(<u>empId</u>, 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