Consider the SQL query below that operates on the table emp containing attributes $($empld$,$ nam gender, salary, deptld$)$:

select deptld, count$(*)$ from emp where gender $=$ "female"

and salary $>($select avg$($salary$)$from emp$)$ group by deptld;

The above query returns, for each department, the number of female workers whose salary is higher than the company's average salary of:

All employees in the department

All employees in the company

All female employees in the department

All female employees in the company