题解 | #汇总各个部门当前员工的title类型的分配数目#
汇总各个部门当前员工的title类型的分配数目
https://www.nowcoder.com/practice/4bcb6a7d3e39423291d2f7bdbbff87f8
select dept_no,dept_name ,title ,count(title) as count from titles as tt join (select aa.emp_no,aa.dept_no ,bb.dept_name from dept_emp as aa join departments as bb on aa.dept_no =bb.dept_no) as dm on tt.emp_no =dm.emp_no group by dept_no,title order by dept_no ,title;
SHEIN希音公司福利 370人发布