2과목) 가장 적절한 SQL은?

SQLD · 0pt

다음 EMPLOYEE 테이블에서 자신이 속한 부서의 평균 급여보다 높은 급여를 받는 사원을 조회하려고 한다. EMPLOYEE - EMP_ID - EMP_NAME - DEPT_ID - SALARY

SELECT E.EMP_ID, E.EMP_NAME FROM EMPLOYEE E WHERE E.SALARY > ( SELECT AVG(X.SALARY) FROM EMPLOYEE X ); SELECT E.EMP_ID, E.EMP_NAME FROM EMPLOYEE E WHERE E.SALARY > ( SELECT AVG(X.SALARY) FROM EMPLOYEE X WHERE X.DEPT_ID = E.DEPT_ID ); SELECT E.EMP_ID, E.EMP_NAME FROM EMPLOYEE E WHERE E.SALARY > ( SELECT X.SALARY FROM EMPLOYEE X WHERE X.DEPT_ID = E.DEPT_ID ); SELECT E.EMP_ID, E.EMP_NAME FROM EMPLOYEE E WHERE E.DEPT_ID > ( SELECT AVG(X.SALARY) FROM EMPLOYEE X WHERE X.EMP_ID = E.DEPT_ID );