WITH cte1 as (
    select id,
            age,
            coins_needed,
             power,
            row_number() over( partition by age,power order by coins_needed ) as rnk
    from wands a 
    left join 
    wands_property b
    on a.code = b.code
    where is_evil = 0    
)

select id, age, coins_needed, power
from 
cte1
where rnk =1 
order by power desc, age desc;