We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
  1. Prepare
  2. SQL
  3. Basic Join
  4. Ollivander's Inventory
  5. Discussions

Ollivander's Inventory

  • kshuckerow
     + 12 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;