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 s.name FROM students s
JOIN friends f ON s.id=f.id JOIN packages p1 ON s.id = p1.id
JOIN packages p2 ON f.friend_id = p2.id WHERE p2.Salary > p1.Salary
ORDER BY p2.Salary;
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 s.name FROM students s JOIN friends f ON s.id=f.id JOIN packages p1 ON s.id = p1.id JOIN packages p2 ON f.friend_id = p2.id WHERE p2.Salary > p1.Salary ORDER BY p2.Salary;