select dept_no,
dept_name,
count(salary) as sum
from departments
right join dept_emp using(dept_no)
right join salaries using(emp_no)
group by dept_no
order by dept_no