Untitled
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...