题解 | 统计各个部门的工资记录数
统计各个部门的工资记录数
https://www.nowcoder.com/practice/6a62b6c0a7324350a6d9959fa7c21db3
select c.dept_no, dept_name, sum
from (
select dept_no, count(1) as sum
from dept_emp a join salaries b on a.emp_no=b.emp_no
group by dept_no
) temp join departments c on temp.dept_no=c.dept_no
order by c.dept_no
查看12道真题和解析