select de.dept_no, e.emp_no, salary
from employees e
left join salaries s
on e.emp_no = s.emp_no
left join dept_emp de
on e.emp_no = de.emp_no
inner join dept_manager dm
on de.dept_no = dm.dept_no and de.emp_no != dm.emp_no
where s.to_date = '9999-01-01'
order by de.dept_no, e.emp_no