SELECT de.dept_no,d.dept_name,COUNT(s.salary) sum
FROM dept_emp de LEFT JOIN departments d on de.dept_no = d.dept_no
RIGHT JOIN salaries s on s.emp_no = de.emp_no GROUP BY d.dept_name order by d.dept_no