Ollivander's Inventory Discussions | SQL | HackerRank

1 day ago+ 0 comments

SELECT
w.id,
wp.age,
w.coins_needed,
w.power
FROM Wands w
LEFT JOIN Wands_Property wp
ON w.code = wp.code
WHERE
wp.is_evil = 0
AND w.coins_needed = (
SELECT MIN(w2.coins_needed)
FROM Wands w2
JOIN Wands_Property wp2
ON w2.code = wp2.code
WHERE
wp2.age = wp.age
AND w2.power = w.power
AND wp2.is_evil = 0
)
ORDER BY
w.power DESC,
wp.age DESC;