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