[HackerRank] Ollivander's Inventory

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

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