select de.dept_no 
,de.emp_no ,salary
from dept_emp de
left join dept_manager dm on dm.emp_no=de.emp_no
join salaries s on s.emp_no=de.emp_no
where dm.emp_no is null
and de.to_date='9999-01-01';