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