Ollivander's Inventory

• 문제
  
• 정답

SELECT id, age, coins_needed, 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 WP1.is_evil = 0
        AND W1.power = W.power
        AND WP.age = WP1.age
    )
ORDER BY W.power DESC, WP.age DESC;

• 결과