select d.dept_no,d.dept_name,sum(1) sum
from departments d join dept_emp de using(dept_no) join salaries s using(emp_no)
group by d.dept_no
order by d.dept_no