select  dt.dept_no,dept_name,count(*) as 'sum'
from departments  dt
join dept_emp  dp using(dept_no)
join salaries  s using(emp_no)
group by dt.dept_no
order by dept_no