[프로그래머스/MySQL] 조건에 맞는 사원 정보 조회하기

문제 :  

https://school.programmers.co.kr/learn/courses/30/lessons/284527

 

 

풀이 : 

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