Hackerrank / Basic Join / Ollivander's Inventory / MySQL
2024. 1. 10. 10:29
📚문제 https://www.hackerrank.com/challenges/harry-potter-and-wands/problem?isFullScreen=true Ollivander's Inventory | HackerRank Help pick out Ron's new wand. www.hackerrank.com 📝풀이 SELECT w.id , p.age , w.coins_needed , w.power FROM Wands w INNER JOIN Wands_Property p ON w.code = p.code WHERE (p.age,w.power,w.coins_needed) IN (SELECT p.age AS age , w.power AS power , MIN(w.coins_needed) AS min_co..