SELECT SCORE, TEMP.EMP_NO, EMP_NAME, POSITION, EMAIL
FROM HR_EMPLOYEES AS HE
RIGHT JOIN
(
SELECT EMP_NO, SUM(SCORE) AS SCORE
FROM HR_GRADE
WHERE YEAR = 2022
GROUP BY 1
ORDER BY SUM(SCORE) DESC
LIMIT 1) AS TEMP ON HE.EMP_NO = TEMP.EMP_NO