select a.dept_no,a.dept_name,count(c.emp_no) SUM
from departments a
join dept_emp b on a.dept_no = b.dept_no
join salaries c on b.emp_no = c.emp_no
group by a.dept_no,a.dept_name
order by a.dept_no