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

  • angel_gt45
     + 2 comments

    SQL Server:

    with cte as 
(select id,age,coins_needed, power,
row_number() over(partition by age,power order by coins_needed) as t
from wands w join wands_property wp
on w.code=wp.code and is_evil=0)

select id,age,coins_needed,power 
from cte where t=1
order by power desc,age desc;