emp表在scott用户下面

select sum(sal) from emp where deptno=10;

select avg(sal) from emp where deptno = 10;

试一试估计你Sql写错了吧