select dm.dept_no,dm.dept_name,count(*)  
from departments dm join dept_emp de on dm.dept_no=de.dept_no
    join salaries s on de.emp_no=s.emp_no
group by dm.dept_no,dm.dept_name
order by dm.dept_no

思路：题目不难，详见代码