We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
select s.name from students s
inner join friends f on s.id = f.id
inner join packages p on f.friend_id = p.id
where p.salary > (select salary from packages p1 where p1.id = s.id)
order by p.salary
Cookie support is required to access HackerRank
Seems like cookies are disabled on this browser, please enable them to open this website
Placements
You are viewing a single comment's thread. Return to all comments →
MySQL Solution:
select s.name from students s inner join friends f on s.id = f.id inner join packages p on f.friend_id = p.id where p.salary > (select salary from packages p1 where p1.id = s.id) order by p.salary