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