• + 0 comments
    with best_friends_salary as (
        select salary, friends.id
        from packages
        join friends on packages.id = friends.friend_id
    )
    select name
    from students
    join best_friends_salary on best_friends_salary.id = students.id
    join packages on packages.id = students.id
    where best_friends_salary.salary > packages.salary
    order by best_friends_salary.salary