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;
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;