You are viewing a single comment's thread. Return to all comments →
select id, age, coins_needed, power from ( select id, p.age, coins_needed, power, row_number() over (partition by p.age, power order by coins_needed asc) as rn from Wands w join Wands_Property p on w.code = p.code where isnull(p.is_evil, 0) <= 0 ) w where rn= 1 order by power desc, age desc, coins_needed desc;
Seems like cookies are disabled on this browser, please enable them to open this website
Ollivander's Inventory
You are viewing a single comment's thread. Return to all comments →