题解 | 统计各个部门的工资记录数
统计各个部门的工资记录数
https://www.nowcoder.com/practice/6a62b6c0a7324350a6d9959fa7c21db3
SELECT S.`dept_no`,S.`dept_name`,Count(s1.`salary`) as sum FROM (SELECT d2.`emp_no`,d2.`dept_no`,d1.`dept_name` FROM `departments` d1 JOIN `dept_emp` d2 ON d1.`dept_no` = d2.`dept_no`) S JOIN `salaries` s1 ON S.`emp_no` = s1.`emp_no` GROUP BY S.`dept_no` ORDER BY S.`dept_no` asc;
猛猛查询
