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.
IN MS SQL Server, i think output of HackerRank is missing some value that have same coins, same age, same power but different ID
with part1 as
(
select wp.age
, min(w.coins_needed) as min_coin
, w.power
from wands as w
left join wands_property as wp
on w.code = wp.code
where wp.is_evil = 0
group by w.power, wp.age
)
-- select * from part1
-- order by power desc, age desc
select w.id
, p.age
, p.min_coin
, p.power
from part1 as p
left join wands as w
on p.min_coin = w.coins_needed and p.power = w.power
order by p.power desc, p.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 →
IN MS SQL Server, i think output of HackerRank is missing some value that have same coins, same age, same power but different ID
with part1 as ( select wp.age , min(w.coins_needed) as min_coin , w.power from wands as w left join wands_property as wp on w.code = wp.code where wp.is_evil = 0 group by w.power, wp.age ) -- select * from part1 -- order by power desc, age desc select w.id , p.age , p.min_coin , p.power from part1 as p left join wands as w on p.min_coin = w.coins_needed and p.power = w.power order by p.power desc, p.age desc;