Please advise, this code giving me name+salary+ managerid and i dont know how to get manager salary
SELECT *
FROM employees.employees emp
JOIN employees.salaries sal ON emp.emp_no = sal.emp_no
JOIN employees.dept_emp dpe ON dpe.emp_no = emp.emp_no
JOIN employees.dept_manager dpm ON dpe.dept_no = dpm.dept_no
WHERE
(sal.emp_no , sal.to_date) IN (
SELECT emp_no, max(to_date)
FROM employees.salaries
GROUP BY emp_no)