문제 설명https://school.programmers.co.kr/learn/courses/30/lessons/284527 입출력 예 풀이SELECT G.SCORE, E.EMP_NO, E.EMP_NAME, E.POSITION, E.EMAILFROM HR_EMPLOYEES E INNER JOIN ( SELECT EMP_NO, SCORE, RANK() OVER(ORDER BY SCORE DESC) AS RNK FROM (SELECT EMP_NO, SUM(SCORE) AS SCORE FROM HR_GRADE WHERE YEAR = '2022' GROUP BY EMP_NO ) AS S ) ..
