题解 | #统计各个部门的工资记录数#

select d.dept_no,ds.dept_name,count(s.salary) as sum
from salaries s
left join dept_emp d on s.emp_no=d.emp_no
left join departments ds on ds.dept_no = d.dept_no
group by d.dept_no
order by d.dept_no;