Untitled

mail@pastecode.io avatar
unknown
plain_text
2 years ago
318 B
1
Indexable
Never
select id,age, coins_needed,power
from wands wand, wands_property prop
where wand.code=prop.code
and is_evil=0
and coins_needed=
(select min(coins_needed) from wands, wands_property
where wands.code=wands_property.code
and wand.power=wands.power
and prop.age=wands_property.age)
order by power desc, age desc;