Untitled

SELECT w.ID, P.AGE, m.coins_needed, w.power from (SELECT code, min(coins_needed) as coins_needed, power from wands group by code, power) as m inner join wands as w on w.code = m.code and w.power = m.power and w.coins_needed = m.coins_needed inner join wands_property as p on p.code = w.code where p.is_evil = 0 order by w.power desc, p.age desc