• + 0 comments
    with cte as(
    select friends.friend_id as fID,packages.salary sly from friends
    inner join packages
    on friends.friend_id=packages.id
    )
    
    select name as nm from friends
    inner join cte
    on friends.friend_id=cte.fID
    inner join students
    on students.id=friends.id
    inner join packages
    on friends.id=packages.id
    where cte.sly>packages.salary
    order by cte.sly ASC