• + 0 comments
    select s.name
    from Students s
    left join Friends f on s.id = f.id
    left join packages own_sal on s.id = own_sal.id
    left join packages frnd_sal on f.friend_id = frnd_sal.id
    where own_sal.salary<frnd_sal.salary
    order by frnd_sal.salary