PierandreaCopy of Copy of Collections Composition - Rarity
    Updated 2022-12-11
    WITH ALLS AS (SELECT
    RARITY,
    DROP_NUMBER,
    ITEM_NO,
    EDITIONS
    from algorand.nft.ez_nft_metadata_fifa
    GROUP BY 1,2,3,4)

    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 Drops,
    SUM(EDITIONS) AS NFTS
    FROM ALLS
    GROUP BY 1
    order by 1 asc
    Run a query to Download Data