프로그래머스 - 조건에 맞는 사원 정보 조회하기

WITH SCORE_SUM AS (
    SELECT SUM(G.SCORE) AS SCORE, G.EMP_NO, E.EMP_NAME, E.POSITION, E.EMAIL
    FROM HR_DEPARTMENT D JOIN HR_EMPLOYEES E ON D.DEPT_ID = E.DEPT_ID JOIN HR_GRADE G ON E.EMP_NO = G.EMP_NO
    GROUP BY G.EMP_NO, E.EMP_NAME, E.POSITION, E.EMAIL
    )
SELECT *
FROM SCORE_SUM
ORDER BY SCORE DESC
LIMIT 1;