Allen's 데이터 맛집

문제  풀이SELECT w.id, p.age, w.coins_needed, w.power FROM Wands AS w JOIN Wands_Property AS p ON (w.code = p.code) WHERE p.is_evil = 0 AND w.coins_needed = (SELECT MIN(coins_needed) FROM Wands AS w1 JOIN Wands_Property AS p1 ON (w1.code = p1.code) WHERE w1.power = w.power AND p1.age = p.age ) ORDER BY w.power DESC, p.age DESC  1. FROM 절과 JOIN 사용: Wands 테이블과 ..