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 id, wp.age age, w.coins_needed coins_needed, w.power power, dense_rank() over (partition by wp.age,w.power order by w.power desc, w.coins_needed) dr from wands w join (select * from wands_property where is_evil=0) wp on w.code=wp.code) where dr=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 id, wp.age age, w.coins_needed coins_needed, w.power power, dense_rank() over (partition by wp.age,w.power order by w.power desc, w.coins_needed) dr from wands w join (select * from wands_property where is_evil=0) wp on w.code=wp.code) where dr=1 order by power desc, age desc;