• + 0 comments
    with t1 as(
    select s.id, s.name, f.friend_id from students s join friends f on s.id = f.id
    ),
    t2 as(
        select t1.id, t1.name, t1.friend_id, p.salary from t1 join packages p on t1.id = p.id
    )
    select t2.name from t2 join packages p on t2.friend_id = p.id where t2.salary<p.salary order by p.salary;