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.
Can anyone please tell me why my solution is not working?
SELECT Students.Name FROM Students JOIN Packages ON Students.ID = Packages.ID
WHERE (SELECT Salary FROM Packages Where Packages.ID = Students.ID ) < (SELECT Salary FROM Packages JOIN Friends ON Packages.ID = Friends.ID Where Packages.ID = Friends.Friend_ID)
ORDER BY (SELECT Salary FROM Packages JOIN Friends ON Packages.ID = Friends.ID Where Packages.ID = Friends.Friend_ID) DESC;
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 →
Can anyone please tell me why my solution is not working?
SELECT Students.Name FROM Students JOIN Packages ON Students.ID = Packages.ID WHERE (SELECT Salary FROM Packages Where Packages.ID = Students.ID ) < (SELECT Salary FROM Packages JOIN Friends ON Packages.ID = Friends.ID Where Packages.ID = Friends.Friend_ID) ORDER BY (SELECT Salary FROM Packages JOIN Friends ON Packages.ID = Friends.ID Where Packages.ID = Friends.Friend_ID) DESC;