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