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.
For sql server:
with bestchoice as (
select w.id, wp.age, w.coins_needed, w.power,
row_number() over (patition by w.power, wp.age order by w.coins_needed asc) as rn
from Wands w join Wands_Property wp on w.code = wp.code
where wp.is_evil = 0
)
select id, age, coins_needed, power
from bestchoice
where rn =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 →
For sql server: with bestchoice as ( select w.id, wp.age, w.coins_needed, w.power, row_number() over (patition by w.power, wp.age order by w.coins_needed asc) as rn from Wands w join Wands_Property wp on w.code = wp.code where wp.is_evil = 0 ) select id, age, coins_needed, power from bestchoice where rn =1 order by power desc, age desc;