题解 | #统计各个部门的工资记录数#
统计各个部门的工资记录数
http://www.nowcoder.com/practice/6a62b6c0a7324350a6d9959fa7c21db3
多表连续连接加分组计数
select t.dept_no,t.dept_name,count(*) from departments as t join dept_emp as c on t.dept_no=c.dept_no join salaries as h on
c.emp_no=h.emp_no group by t.dept_no order by dept_no;
查看13道真题和解析
