SELECT
    d.dept_no,
    d.dept_name,
    COUNT(*) sum
FROM dept_emp de
JOIN departments d ON d.dept_no = de.dept_no
JOIN salaries s ON s.emp_no = de.emp_no
GROUP BY d.dept_no
ORDER BY d.dept_no