题解 | #汇总各个部门当前员工的title类型的分配数目#

select new1.dept_no as dept_no, new1.dept_name dept_name, titles.title title, count(new1.dept_no) as count
from
(select dept_emp.dept_no, dept_name, emp_no
from dept_emp left join departments on departments.dept_no = dept_emp.dept_no) as new1 left join titles on new1.emp_no = titles.emp_no
group by new1.dept_no, new1.dept_name, titles.title
order by new1.dept_no, title