Oracle

WITH SalaryComparison AS (
    SELECT
        f.id as self_id,
        pf.salary AS friend_salary,
        ps.salary AS self_salary
    FROM
        Friends f
        JOIN Packages pf ON f.friend_id = pf.id
        JOIN Packages ps ON f.id = ps.id
)
SELECT 
    s.name
FROM 
    SalaryComparison sc
    JOIN Students s ON sc.self_id = s.id
WHERE
    sc.friend_salary > sc.self_salary
ORDER BY
    sc.friend_salary ASC
;

SELECT NAME from Students s LEFT JOIN Friends f ON s.ID=f.ID LEFT JOIN Packages p ON f.ID=p.ID LEFT JOIN Packages p1 ON f.Friend_ID=p1.ID WHERE p1.salary>p.salary Order BY p1.salary;

SELECT NAME from Students s LEFT JOIN Friends f ON s.ID=f.ID LEFT JOIN Packages p ON f.ID=p.ID LEFT JOIN Packages p1 ON f.Friend_ID=p1.ID WHERE p1.salary>p.salary Order BY p1.salary;

MySQL select s.name from students s left join friends f on s.id = f.id left join packages p on f.id = p.id left join packages p1 on f.friend_id = p1.id where p1.salary>p.salary order by p1.salary

WITH CTE AS( SELECT S.ID, S.Name, P.Salary,F.Friend_ID FROM Students AS S INNER JOIN Packages AS P ON S.ID=P.ID INNER JOIN Friends AS F ON S.ID=F.ID ) , CTE2 AS( SELECT CTE.Name AS StudentName, CTE.Salary AS StudentSalary, Students.Name AS FriendName, Packages.Salary AS FriendSalary FROM CTE INNER JOIN Students ON CTE.Friend_ID=Students.ID INNER JOIN Packages ON Packages.ID=CTE.Friend_ID ) , CTE3 AS( SELECT CASE WHEN StudentSalary