SELECT d2.dept_no, dept_name, count(salary) as sum
FROM dept_emp d1
LEFT JOIN departments d2 on d1.dept_no = d2.dept_no
INNER JOIN salaries s on d1.emp_no=s.emp_no
GROUP BY d2.dept_no
ORDER BY d2.dept_no asc