PierandreaCopy of Collections Composition - Drops
    Updated 2022-12-11
    WITH drops 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,
    MAX(ITEM_NO) AS Collectibles
    FROM algorand.nft.ez_nft_metadata_fifa
    GROUP BY DROP_NUMBER
    Order by DROP_NUMBER ASC),

    ALLS AS (SELECT
    RARITY,
    DROP_NUMBER,
    ITEM_NO,
    EDITIONS
    from algorand.nft.ez_nft_metadata_fifa
    GROUP BY 1,2,3,4),

    ED 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 Drops,
    MAX(ITEM_NO) AS Collectibles,
    SUM(EDITIONS) AS EDITIONS
    FROM ALLS,drops
    GROUP BY 1
    order by 1 asc)

    SELECT
    SUM(Collectibles)
    FROM
    ED
    Run a query to Download Data