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 w.id, p.age, w.coins_needed, w.power FROM Wands w JOIN Wands_Property p
ON w.code = p.code
WHERE p.is_evil = 0 AND
w.coins_needed = ( SELECT MIN(w1.coins_needed) FROM Wands w1 JOIN Wands_Property p1
ON w1.code = p1.code
WHERE w1.power = w.power AND p1.age = p.age )
ORDER BY w.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 →
SELECT w.id, p.age, w.coins_needed, w.power FROM Wands w JOIN Wands_Property p ON w.code = p.code WHERE p.is_evil = 0 AND w.coins_needed = ( SELECT MIN(w1.coins_needed) FROM Wands w1 JOIN Wands_Property p1 ON w1.code = p1.code WHERE w1.power = w.power AND p1.age = p.age ) ORDER BY w.power DESC, p.age DESC;