# 题目应当说清楚一点，优先以emp_no排序
select
    dm.emp_no,
    s.salary,
    s.from_date,
    dm.to_date,
    dm.dept_no
from
    dept_manager dm left join salaries s
    on dm.emp_no = s.emp_no
order by dm.emp_no asc,s.salary asc
;