You are viewing a single comment's thread. Return to all comments →
WITH friend AS( SELECT Friends.id as id1, friend_id, Salary as salary1 FROM Friends JOIN Packages ON Friends.friend_id = Packages.id),
student AS ( SELECT Students.id as id2, Name, Salary as salary2 FROM Students JOIN Packages ON Students.id = Packages.id)
SELECT Name FROM student JOIN friend ON friend.id1 = student.id2 WHERE salary1 > salary2 ORDER BY salary1
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 →
WITH friend AS( SELECT Friends.id as id1, friend_id, Salary as salary1 FROM Friends JOIN Packages ON Friends.friend_id = Packages.id),
student AS ( SELECT Students.id as id2, Name, Salary as salary2 FROM Students JOIN Packages ON Students.id = Packages.id)
SELECT Name FROM student JOIN friend ON friend.id1 = student.id2 WHERE salary1 > salary2 ORDER BY salary1