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
a.name
from
students a
left join(
select
b.id,
b.friend_id,
c.salary
from
friends b
left join packages c on b.friend_id = c.id
) e on a.id = e.id
left join packages d on a.id = d.id
where
e.salary > d.salary
order By
e.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 a.name from students a left join( select b.id, b.friend_id, c.salary from friends b left join packages c on b.friend_id = c.id ) e on a.id = e.id left join packages d on a.id = d.id where e.salary > d.salary order By e.salary