-- 练习：查询每个工资等级的员工人数（每个工资登记都要统计）
select grade,count(empno) 员工人数
from salgrade
left join emp
on sal between losal and hisal
group by grade;