PierandreaUntitled Query
    Updated 2022-12-09
    WITH X AS ( SELECT
    CASE
    WHEN DROP_NUMBER = '1' THEN '1 -Genesis Drop'
    WHEN DROP_NUMBER = '2' THEN '2 -FIFA Archive Drop'
    WHEN DROP_NUMBER = '3' THEN '3 -Curator Collection - South American Flair'
    WHEN DROP_NUMBER = '4'THEN '4 -FIFA Archive 2 Drop'
    END AS Edition,
    Rarity
    FROM algorand.nft.ez_nft_metadata_fifa
    GROUP BY DROP_NUMBER, Rarity
    Order by EDITION ASC),

    B AS (
    SELECT
    DROP_NUMBER,
    Rarity,
    MAX(Editions)
    FROM algorand.nft.ez_nft_metadata_fifa
    GROUP BY DROP_NUMBER, Rarity

    )
    Run a query to Download Data