[HackerRank] The Report

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

SELECT CASE
            WHEN G.Grade >= 8 THEN S.Name
            ELSE Null
        END AS Name
     , G.Grade
     , S.Marks
FROM Students AS S
    INNER JOIN Grades AS G ON S.Marks BETWEEN G.Min_Mark AND G.Max_Mark
ORDER BY G.Grade DESC, Name ASC, S.Marks ASC