题解 | #统计各个部门的工资记录数#
统计各个部门的工资记录数
http://www.nowcoder.com/practice/6a62b6c0a7324350a6d9959fa7c21db3
很简单的一道题目,三个表进行连接即可
select a.dept_no ,a.dept_name,count(a.dept_no) as sum from departments a, dept_emp b, salaries c where a.dept_no = b.dept_no and b.emp_no = c.emp_no group by a.dept_no order by a.dept_no;

