You are viewing a single comment's thread. Return to all comments →
with min_gold_gal as ( select w.id as id, wp.age as age, w.coins_needed as coins_needed, w.power as power, dense_rank() over(partition by w.power, wp.age order by w.coins_needed) as min_coins from wands w join wands_property wp on w.code = wp.code where wp.is_evil = 0 ) select id, age, coins_needed, power from min_gold_gal where min_coins = 1 order by 4 desc, 2 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 →