What does this code do$?$

$56783421$

SELECT e$.$employee$\_$id$,$ e$.$first$\_$name, e$.$last$\_$name, e$.$salary

FROM employees e

WHERE e$.$salary $>($

SELECT AVG$($salary$)$

FROM employees

WHERE department$\_$id $=$ e$.$department$\_$id

$)$;

$1$ point

It finds employees who earn more than the average salary in their department.

It calculates the average salary for all employees.

It groups employees by department.

It joins the employees table with itself.