You are viewing a single comment's thread. Return to all comments →
FROM ( SELECT F.ID AS ID, S.Name AS Name, F.Friend_ID AS F_ID, S2.Name AS F_Name FROM Friends AS F LEFT JOIN Students AS S ON F.ID = S.ID LEFT JOIN Students AS S2 ON F.Friend_ID = S2.ID ) AS T1 JOIN Packages AS P ON T1.ID = P.ID JOIN Packages AS P2 ON T1.F_ID = P2.ID WHERE P2.Salary > P.Salary ORDER BY P2.Salary
Seems like cookies are disabled on this browser, please enable them to open this website
I agree to HackerRank's Terms of Service and Privacy Policy.
Placements
You are viewing a single comment's thread. Return to all comments →