Вывести список сотрудников, получающих максимальную заработную плату в своем отделе

select e.LAST_NAME
from EMPLOYEES e
where e.SALARY = (select max(ee.salary)
from EMPLOYEES ee
group by ee.DEPARTMENT_ID
HAVING ee.DEPARTMENT_ID = e.DEPARTMENT_ID)



with dep_max as (select ee.DEPARTMENT_ID, max(ee.salary) sal
from EMPLOYEES ee
group by ee.DEPARTMENT_ID
)

select e.LAST_NAME, e.DEPARTMENT_ID, e.SALARY,
d.sal
from EMPLOYEES e,
dep_max d
where e.DEPARTMENT_ID = d.DEPARTMENT_ID
and e.SALARY = d.sal
ORDER BY e.DEPARTMENT_ID