What does this query do? SELECT employee_number, name FROM employees AS Parent WHERE salary> (SELECT AVG (salary) FROM employees WHERE department=…

What does this query do?

SELECT employee_number, name FROM
employees AS Parent WHERE salary> (SELECT AVG (salary)
FROM employees WHERE department= Parent.department);

1. a) Finds the name and ID of employees who get more than average
2. b) Finds the employee's name and ID of those who get more than average salaries of all the departments' salaries.
3. c) Finds the name and ID of employees who get more than average salaries of his own department.
4. d) None