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