select ranksala.dept_no, ranksala.emp_no, ranksala.salaryfrom(selectsala.dept_no,sala.emp_no,sala.salary,row_number() over(partition by sala.dept_no order by sala.salary desc) as ASDfrom( select A.emp_no, A.dept_no, B.salary from dept_emp as A left join salaries as B on A.emp_no = B.emp_no) as sa...