You are viewing a single comment's thread. Return to all comments →
Can't figure out where i'm going wrong.. I've checked for duplicate rows and minimums... Am I missing something? I've been stuck on this for 3 days.
SELECT id, age, coins_needed, power
FROM WANDS_PROPERTY JOIN WANDS on WANDS.code = WANDS_property.code
WHERE is_evil = 0
GROUP BY age, power
ORDER BY power DESC, age DESC;