코딩연습이 좋아서/SQL이 좋아서
부서별 평균 연봉 조회하기
zoaseo
2025. 2. 4. 23:57
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;