题解 | 汇总各个部门当前员工的title类型的分配数目
select dept_no,dept_name,title,count(*) as count from( select t2.*,t1.dept_name,t3.title from departments as t1 inner join dept_emp as t2 on t1.dept_no = t2.dept_no inner join titles as t3 on t2.emp_no = t3.emp_no) as t group by dept_no,dept_name,title order by dept_no asc,title asc;
查看6道真题和解析