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

select departments.dept_no, dept_name, count(salaries.salary)
from dept_emp left join departments on dept_emp.dept_no=departments.dept_no
right join salaries on dept_emp.emp_no=salaries.emp_no
group by departments.dept_no
order by departments.dept_no