Select Wands_Property.age,
Wands.code,
min(Wands.coins_needed) as MinCoinsNeeded,
Wands.power --min(Wands.coins_needed)
into #temp1
from Wands
join Wands_Property 
on Wands.code = Wands_Property.code and Wands_Property.is_evil = 0
group by Wands.power,Wands_Property.age,Wands.code


Select Wands.id,
#temp1.age,MinCoinsNeeded, #temp1.power
from #temp1
join Wands_Property on #temp1.age = Wands_Property.age
join Wands 
on wands.code = #temp1.code 
and #temp1.MinCoinsNeeded=Wands.coins_needed 
order by #temp1.power desc,#temp1.age desc