[HackerRank] MySQL - Ollivander's Inventory

https://www.hackerrank.com/challenges/harry-potter-and-wands/problem?isFullScreen=true

Ollivander's Inventory | HackerRank

 

select a.id, b.age, a.coins_needed, a.power
from wands as a
join wands_property as b on a.code=b.code
where is_evil = 0
and a.coins_needed = (
	select min(w.coins_needed)
    from wands as w
    join wands_property as wp
    on w.code=wp.code
    where is_evil = 0
    and b.age = wp.age
    and a.power = w.power)
order by a.power desc, b.age desc