select d.dept_no, d.emp_no, d.salary from (select c.dept_no,c.emp_no,c.salary, row_number() over(partition by c.dept_no order by c.salary desc) as ranking from (select a.dept_no,a.emp_no,b.salary from dept_emp as a inner join salar...