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

  • debjyoti_ghosh
     + 0 comments
    /* MS - SQL Server */
with cte as
(
select
    w.id,
    wp.age,
    w.coins_needed,
    w.power,
    dense_rank() over(partition by w.power, wp.age order by w.coins_needed) dr
from
    Wands w
left join Wands_Property wp on w.code = wp.code
where
    wp.is_evil = 0
)
select id, age, coins_needed, power
from cte
where dr = 1
order by
    power desc,
    age desc;