부서별 평균 연봉 조회하기

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