11.列出公司各个工资等级雇员的数量、平均工资
确定所需要的数据表:
emp表:雇员的平均工资
salgrade表:工资等级
确定已知的关联字段:
emp.sal BETWEEN salgrade.losal AND salgrade.hisal
SELECT s.grade,COUNT(e.empno),AVG(e.sal)
FROM emp e ,salgrade s
WHERE e.sal BETWEEN s.losal AND s.hisal
GROUP BY s.grade;