思路：以部门领导表为主表连接薪水表
select
s.*
,d.dept_no
from salaries s 
right join dept_manager d 
on d.emp_no = s.emp_no
order by s.emp_no