Ollivander's Inventory

  • + 0 comments
    SELECT
        A.id
        , B.age
        , A.coins_needed
        , A.power
    FROM
        Wands A
        INNER JOIN Wands_Property B
            ON A.code = B.code
    WHERE
        NOT is_evil
        AND (A.code, A.coins_needed, A.power) IN (
            SELECT
                code
                , MIN(coins_needed)
                , power
            FROM
                Wands
            GROUP BY
                code
                , power
            )
    ORDER BY
        A.power DESC
        , B.age DESC