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 Wands
inner join Wands_Property
on Wands_Property.code = Wands.code
where is_evil=0
and coins_needed =(
SELECT MIN(w1.coins_needed)
FROM Wands w1
JOIN Wands_Property wp1 ON w1.code = wp1.code
WHERE wp1.is_evil = 0
AND w1.power = wands.power
AND wp1.age = Wands_Property.age)
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 Wands inner join Wands_Property on Wands_Property.code = Wands.code where is_evil=0 and coins_needed =( SELECT MIN(w1.coins_needed) FROM Wands w1 JOIN Wands_Property wp1 ON w1.code = wp1.code WHERE wp1.is_evil = 0 AND w1.power = wands.power AND wp1.age = Wands_Property.age) order by power desc,age desc