• + 1 comment

    MY SQL

    SELECT NAME FROM STUDENTS S, FRIENDS F, PACKAGES P1, PACKAGES P2 
    WHERE
    S.ID=F.ID AND S.ID=P1.ID AND F.FRIEND_ID=P2.ID AND P1.SALARY < P2.SALARY
    ORDER BY P2.SALARY;