--12.查询EMP表,输出每个职位的平均工资,按平均工资升序排列. select job , avg(sal) from emp group by job order by avg(sal) ; --13.查询EMP表,输出每个部门的各个职位的平均工资,并按部门编号升序、平均工资降序排序。 select deptno , job , avg(sal) from emp group by deptno , job order by ...