题目：查询出部门平均工资超过Smith所在部门平均工资的部门名称 我做不出来，代码打出来都是值过多出错。 SQL> select ename,sal from emp 2 where sal>(select avg(sal) from emp where deptno=(select deptno from emp wh ere ename='SMITH') ); 这个是工资超过SMITH的代码，成功了，但还是打不出题目的代码，请求帮助！！！
SELECT DNAME FROM DEPT WHERE DEPTNO IN (SELECT DEPTNO FROM (SELECT deptno, avg(sal) A FROM emp GROUP BY deptno) WHERE A > (SELECT avg(sal) FROM emp where DEPTNO IN (SELECT DEPTNO FROM EMP WHERE ENAME = 'SMITH') GROUP BY deptno));
