牛客SQL学习 _17_216 统计各个部门的工资记录数

---

一、题目

二、代码

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

三、运行结果