• + 0 comments
    FROM 
    (   
        SELECT  F.ID AS ID, 
    		S.Name AS Name, 
    		F.Friend_ID AS F_ID, 
    		S2.Name AS F_Name
        FROM Friends AS F
        LEFT JOIN Students AS S ON F.ID = S.ID
        LEFT JOIN Students AS S2 ON F.Friend_ID = S2.ID
    ) AS T1
    
    JOIN Packages AS P ON T1.ID = P.ID
    JOIN Packages AS P2 ON T1.F_ID = P2.ID
    WHERE P2.Salary > P.Salary
    ORDER BY P2.Salary