[GROUP BY/LEVEL3] 부서별 평균 연봉 조회하기 (MySQL)

MySQL

SELECT A.DEPT_ID
, DEPT_NAME_EN
, ROUND(AVG(SAL),0) AS AVG_SAL
FROM HR_DEPARTMENT A, HR_EMPLOYEES B
WHERE A.DEPT_ID = B.DEPT_ID
GROUP BY DEPT_ID, DEPT_NAME_EN
ORDER BY AVG_SAL DESC