• + 0 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;