#1.将salaries和dept_manager进行联结
#2.根据部门号分组group by a.emp_no 
select a.*,b.dept_no
from salaries as a
join  dept_manager as b
on a.emp_no=b.emp_no
group by a.emp_no