Medium: Question 8

/* Question 8: Medium */

SELECT STUDENTS.NAME
FROM STUDENTS
JOIN PACKAGES ON STUDENTS.ID = PACKAGES.ID
JOIN FRIENDS ON STUDENTS.ID = FRIENDS.ID
JOIN PACKAGES AS FRIENDS_PACKAGES ON FRIENDS.FRIEND_ID = FRIENDS_PACKAGES.ID
WHERE PACKAGES.SALARY < FRIENDS_PACKAGES.SALARY
ORDER BY FRIENDS_PACKAGES.SALARY ASC;