一、题目
二、代码
/*
可以双重分组 直接写即可
*/
select table1.dept_no,table1.dept_name,ti.title,count(ti.title) as counts
from
(
select departments.dept_no, departments.dept_name, dept_emp.emp_no
from departments
left join dept_emp
on departments.dept_no = dept_emp.dept_no
) table1
join titles ti
on table1.emp_no = ti.emp_no
group by table1.dept_no,ti.title
order by table1.dept_no asc, ti.title asc