select d.dept_no,de.dept_name,count(s.emp_no) as sum
from dept_emp as d left join salaries as s on s.emp_no=d.emp_no
left join departments as de on d.dept_no=de.dept_no
group by dept_no
order by dept_no;
题目解答注意此题的主表是部门表,应放在联结的第一个位置select d.dept_no,de.dept_name,count(s.emp_no) as sumfrom dept_emp as d left join salaries as s on s.emp_no=d.emp_no left join departments as de on d.dept_no=de.dept_nogroup by dept_noorder by dept_no;