Medium 8
Manishyadav514
mysql
4 years ago
265 B
6
Indexable
SELECT name FROM students INNER JOIN friends ON students.id = friends.id INNER JOIN packages salary_1 ON students.id = salary_1.id INNER JOIN packages salary_2 ON friends.friend_id = salary_2.id WHERE salary_2.salary > salary_1.salary ORDER BY salary_2.salary
Editor is loading...