Q31

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