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 NAME from Students s LEFT JOIN Friends f ON s.ID=f.ID LEFT JOIN Packages p ON f.ID=p.ID LEFT JOIN Packages p1 ON f.Friend_ID=p1.ID WHERE p1.salary>p.salary Order BY p1.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 NAME from Students s LEFT JOIN Friends f ON s.ID=f.ID LEFT JOIN Packages p ON f.ID=p.ID LEFT JOIN Packages p1 ON f.Friend_ID=p1.ID WHERE p1.salary>p.salary Order BY p1.salary;