[HackerRank] Placements

 

 

[문제]

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

 

 

[MySQL]

SELECT S.Name
FROM Students AS S
    INNER JOIN Friends AS F ON S.ID = F.ID
    INNER JOIN Packages AS P1 ON P1.ID = F.ID
    INNER JOIN Packages AS P2 ON P2.ID = F.Friend_ID
WHERE P1.Salary < P2.Salary
ORDER BY P2.Salary