You are viewing a single comment's thread. Return to all comments →
Oracle/MySQL
select id, age, coins_needed, power from ( select id, age, coins_needed, power, rank() over(partition by age, power order by coins_needed) rnk from ( select id, coins_needed, power, (select age from wands_property where code = w.code) age, (select is_evil from wands_property where code = w.code) is_evil from wands w) where is_evil = 0) where rnk = 1 order by power desc, age 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 →
Oracle/MySQL