• + 0 comments

    with cte_stu as( select F.ID,s.name,P.Salary from Friends F join Packages P on F.ID=P.ID join Students s on F.ID=s.ID),

    cte_fri as(
    select F.Friend_ID,s.name,P.Salary
    from Friends F join Packages P on Friend_ID=P.ID
    join Students s on  Friend_ID=s.ID)
    

    Select st.name from
    cte_stu St join Friends F on ST.ID=F.ID join cte_fri fr on fr.Friend_ID=F.Friend_ID where Fr.salary > st.Salary order by fr.salary