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 id,age,coins_needed,power from(
select rank() over(partition by power,age order by coins_needed) rno,id,age,coins_needed,power from wands w inner join wands_property p
on w.code=p.code
where is_evil=0
)x
where x.rno=1
order by power desc,age desc;
Cookie support is required to access HackerRank
Seems like cookies are disabled on this browser, please enable them to open this website
Find Angle MBC
You are viewing a single comment's thread. Return to all comments →
select id,age,coins_needed,power from( select rank() over(partition by power,age order by coins_needed) rno,id,age,coins_needed,power from wands w inner join wands_property p on w.code=p.code where is_evil=0 )x where x.rno=1 order by power desc,age desc;