부서별 평균 연봉 조회하기

https://school.programmers.co.kr/learn/courses/30/lessons/284529

프로그래머스

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