PierandreaCollections Composition - Drops
    Updated 2023-06-08
    --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)

    --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
    Run a query to Download Data