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
join friends f
on s.id = f.id
join
(
select salary, id from packages where id in (select friend_id from friends)
) f_sal
on f_sal.id = f.Friend_ID
join packages p
on s.id = p.id
where f_sal.salary > p.salary
order by f_sal.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 →
select s.name from students s join friends f on s.id = f.id join ( select salary, id from packages where id in (select friend_id from friends) ) f_sal on f_sal.id = f.Friend_ID join packages p on s.id = p.id where f_sal.salary > p.salary order by f_sal.salary ;