You are viewing a single comment's thread. Return to all comments →
hi! Can anyone explain why this query is not correct? The results seem to fit the requirements .. unless I misunderstood them:
SELECT W.ID, WP.AGE, MIN(W.COINS_NEEDED) AS MIN_COINS, W.POWER FROM WANDS W JOIN WANDS_PROPERTY WP ON W.CODE = WP.CODE WHERE WP.IS_EVIL = 0 GROUP BY W.POWER, WP.AGE ORDER BY W.POWER DESC, WP.AGE DESC
cheers
Seems like cookies are disabled on this browser, please enable them to open this website
Ollivander's Inventory
You are viewing a single comment's thread. Return to all comments →
hi! Can anyone explain why this query is not correct? The results seem to fit the requirements .. unless I misunderstood them:
cheers