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(\underline{empId}, name, gender, salary, deptId)
Consider the following SQL query:
The above query gives, for each department in the company, the number of female employees whose salary is greater than the average salary of
sql
- Aemployees in the department.
- Bemployees in the company.
- Cfemale employees in the department.
- Dfemale employees in the company.

