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.
Loading...
  1. Practice
  2. SQL
  3. Basic Join
  4. Ollivander's Inventory
  5. Discussions

Ollivander's Inventory

  • achalshah20 + 1 comment

    Can you please explain how 

    W.coins_needed = 
(SELECT MIN(coins_needed)
FROM WANDS AS W1
INNER JOIN WANDS_PROPERTY AS P1 ON W1.code = P1.code
WHERE W1.power = W.power AND P1.age = P.age)

    is different than

    group by W.power, W.age
having MIN(W.coins_needed)

    Thanks

    • payalbhatia_ece + 0 comments

      Please follow the link and interpret the output by running query separately :

      https://stackoverflow.com/questions/2421388/using-group-by-on-multiple-columns