부서별 평균 연봉 조회하기

문제

코드

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

 

출처: 프로그래머스 코딩 테스트 연습, https://school.programmers.co.kr/learn/courses/30/lessons/284529