select a.dept_no,a.dept_name,count(salary) sum from departments a,
(select d.dept_no,salary from dept_emp d,salaries s
where d.emp_no=s.emp_no) b
where a.dept_no=b.dept_no
group by a.dept_no order by a.dept_no asc;