select e.dept_no,
    dept_name,
    count(salary) as sum
from salaries s right join dept_emp e on s.emp_no = e.emp_no
    right join departments d on d.dept_no = e.dept_no
group by
    d.dept_no
order by
    d.dept_no ASC;