select departments.*,count(salaries.salary)as sum from departments
right join dept_emp on departments.dept_no=dept_emp.dept_no 
left join salaries on dept_emp.emp_no=salaries.emp_no
group by 1,2
order by departments.dept_no