select salaries.emp_no, salaries.salary, salaries.from_date, salaries.to_date, dept_no
from salaries right join dept_manager on salaries.emp_no = dept_manager.emp_no 
order by salaries.emp_no