조건에 맞는 사원 정보 조회하기

SELECT SUM(A.SCORE) AS SCORE,
B.EMP_NO,
B.EMP_NAME,
B.POSITION,
B.EMAIL
FROM HR_GRADE A
JOIN HR_EMPLOYEES B ON A.EMP_NO = B.EMP_NO
JOIN HR_DEPARTMENT C ON B.DEPT_ID = C.DEPT_ID
GROUP BY A.EMP_NO
ORDER BY SCORE DESC LIMIT 1;