You are viewing a single comment's thread. Return to all comments →
SELECT s.Name
FROM Friends f
JOIN Packages p1 ON f.ID = p1.ID
JOIN Packages p2 ON f.Friend_ID = p2.ID
JOIN Students s ON f.ID = s.ID
WHERE p2.Salary > p1.Salary ORDER BY p2.Salary;
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 Friends f
JOIN Packages p1 ON f.ID = p1.ID
JOIN Packages p2 ON f.Friend_ID = p2.ID
JOIN Students s ON f.ID = s.ID
WHERE p2.Salary > p1.Salary ORDER BY p2.Salary;