We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
SELECT Students.Name
FROM (
SELECT Friends.ID, Friends.Friend_ID, Packages.Salary as Friend_Salary FROM Friends
JOIN Packages ON Packages.ID = Friends.Friend_ID) as a
JOIN Students ON a.ID = Students.ID
JOIN Packages ON a.ID = Packages.ID
WHERE a.Friend_Salary > Packages.Salary
ORDER BY a.Friend_Salary ASC;
Cookie support is required to access HackerRank
Seems like cookies are disabled on this browser, please enable them to open this website
Placements
You are viewing a single comment's thread. Return to all comments →
SELECT Students.Name FROM ( SELECT Friends.ID, Friends.Friend_ID, Packages.Salary as Friend_Salary FROM Friends JOIN Packages ON Packages.ID = Friends.Friend_ID) as a JOIN Students ON a.ID = Students.ID JOIN Packages ON a.ID = Packages.ID WHERE a.Friend_Salary > Packages.Salary ORDER BY a.Friend_Salary ASC;