• + 0 comments

    With Cte As ( Select S.ID,S.Name,P.Salary From Students As S Join Packages As P On S.ID = P.ID ) , CteFriend As ( Select C.* ,F.Friend_ID From Cte As C Join Friends As F On C.ID = F.ID

    ) Select Name from CteFriend As Cf Join Packages As P On Cf.Friend_ID = P.ID Where Cf.Salary < P.Salary Order by p.Salary