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
--, S1.Name as FriendName,P.Salary,P1.Salary as FriendSalary
FROM Friends F
LEFT JOIN Students S
ON F.Id = S.Id
LEFT JOIN Students S1
ON F.friend_ID = S1.Id
LEFT JOIN Packages P
ON P.Id = F.Id
LEFT JOIN Packages P1
ON P1.Id = F.friend_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 S.Name --, S1.Name as FriendName,P.Salary,P1.Salary as FriendSalary FROM Friends F LEFT JOIN Students S ON F.Id = S.Id LEFT JOIN Students S1 ON F.friend_ID = S1.Id LEFT JOIN Packages P ON P.Id = F.Id LEFT JOIN Packages P1 ON P1.Id = F.friend_ID WHERE P1.Salary>P.Salary Order by P1.Salary