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 id,age,coins_needed,power,row_number() over(partition by age,power order by age,coins_needed asc) rnk from wands inner join wands_property on wands.code=wands_property.code where is_evil=0
)src where rnk=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 →
simple solution:
select id,age,coins_needed,power from ( select id,age,coins_needed,power,row_number() over(partition by age,power order by age,coins_needed asc) rnk from wands inner join wands_property on wands.code=wands_property.code where is_evil=0 )src where rnk=1 order by power desc,age desc;