select de.dept_no, dept_name, count(*) as `sum`
from dept_emp de
join departments d
on de.dept_no=d.dept_no
join salaries s
on de.emp_no=s.emp_no
group by de.dept_no
order by dept_no;