The relation scheme given below is used to store information about the employees of a company, where $\textsf{empId}$ is the key and $\textsf{deptId}$ indicates the department to which the employee is assigned. Each employee is assigned to exactly one department.
$$\textsf{emp($\underline{\textsf{empId}}$, name, gender, salary, deptId)}$$
Consider the following $\text{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
- employees in the department
- employees in the company
- female employees in the department
- female employees in the company