Ollivander's Inventory

  • + 2 comments

    my solution in oracle using window function

    select id,age,coins_needed,power   from (
    select id,age,coins_needed,power, min(coins_needed) over (partition by w.code,age,power) as min_coins from wands w 
    inner join wands_property wp on w.code = wp.code
    where wp.is_evil =0
    ) where coins_needed = min_coins 
    order by power desc,age desc;