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 w.id, wp.age, w.coins_needed, w.power ,
ROW_NUMBER() over(partition by power,age order by w.coins_needed) as ranking
from wands w
join wands_property wp
on w.code = wp.code
where wp.is_evil = 0)
where ranking = 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
Ollivander's Inventory
You are viewing a single comment's thread. Return to all comments →
select id, age, coins_needed, power from( select w.id, wp.age, w.coins_needed, w.power , ROW_NUMBER() over(partition by power,age order by w.coins_needed) as ranking from wands w join wands_property wp on w.code = wp.code where wp.is_evil = 0) where ranking = 1 order by power desc, age desc;