Untitled

 avatar
user_9914919852
mysql
4 years ago
282 B
3
Indexable
SELECT w.id, wp.age, w.coins_needed, w.power FROM Wands w
JOIN Wands_property wp on w.code = wp.code
WHERE wp.is_evil = 0 AND w.coins_needed = (
    SELECT min(w2.coins_needed) FROM Wands w2
    WHERE w2.power = w.power and w2.code = w.code)
ORDER BY w.power DESC, wp.age DESC;
Editor is loading...