We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
  1. Prepare
  2. SQL
  3. Basic Join
  4. Ollivander's Inventory
  5. Discussions

Ollivander's Inventory

  • h2001203004
     + 0 comments

    Here's my solution in MS SQL Server:

    with ranked as (
    select 
        w.id,
        p.age,
        w.coins_needed,
        w.power,
        row_number() over (partition by power, age order by coins_needed) as rn
    from 
        wands w, 
        wands_property p
    where 
        w.code = p.code 
        and p.is_evil = 0
)
select 
    id,
    age,
    coins_needed,
    power
from 
    ranked
where 
    rn = 1
order by 
    power desc, 
    age desc;