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 HAVING MIN(coins_needed) ORDER BY power DESC, age DESC;
Ollivander's Inventory
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.