[SQL문제풀기] 부서별 평균 연봉 조회하기

문제

MYSQL

내가 작성한 정답

SELECT D.DEPT_ID, D.DEPT_NAME_EN, ROUND(AVG(E.SAL)) AVG_SAL
FROM HR_EMPLOYEES E
JOIN HR_DEPARTMENT D ON D.DEPT_ID = E.DEPT_ID
GROUP BY DEPT_ID, DEPT_NAME_EN
ORDER BY 3 DESC;