/*
子查询结果建立新表 t1：
1001 d001 (分组聚合后)    d001 3
1001 d001 - - - - - - ->
1002 d001                         d002 1
1003 d002

/
select d.,t1.sumNumbers
from departments as d
left join (
select d_e.dept_no,count(*) as sumNumbers
from salaries as s left outer join dept_emp as d_e
on s.emp_no = d_e.emp_no
group by d_e.dept_no) as t1
on d.dept_no = t1.dept_no