Untitled

 avatar
user_1196610317
mysql
4 years ago
261 B
5
Indexable
SELECT s1.Name FROM Students s1
    INNER JOIN Friends f1 ON s1.ID = f1.ID
    INNER JOIN Students s2 ON f1.Friend_ID = s2.ID
    INNER JOIN Packages p1 ON s1.ID = p1.ID
    INNER JOIN Packages p2 ON s2.ID = p2.ID
WHERE p2.Salary > p1.Salary ORDER BY p2.Salary;
Editor is loading...