You are viewing a single comment's thread. Return to all comments →
cte AS (SELECT a.id id, a.friend_id fid, b.name name, c.salary sly FROM Friends a INNER JOIN Students b ON a.friend_id = b.id INNER JOIN Packages c ON a.friend_id = c.id) SELECT a.name FROM Students a INNER JOIN cte b ON a.id = b.id INNER JOIN Packages c ON a.id = c.id WHERE c.salary < b.sly ORDER BY b.sly;
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 →