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 p.id=s.id
inner join packages p1 on p1.id=f.friend_id
where (p1.salary-p.salary)>0
order by p1.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 →
simple in mysql, use alias:
select s.name from students s inner join friends f on s.id=f.id inner join packages p on p.id=s.id inner join packages p1 on p1.id=f.friend_id where (p1.salary-p.salary)>0 order by p1.salary;