Pierandrea Collections Composition - Rarity
    Updated 2023-04-12
    WITH ALLS AS (SELECT
    RARITY,
    DROP_NUMBER,
    ITEM_NO,
    EDITIONS
    from algorand.nft.ez_nft_metadata_fifa
    GROUP BY 1,2,3,4)

    SELECT
    RARITY,
    COUNT(EDITIONS) AS COLLECTIBLES,
    SUM(EDITIONS) AS EDITIONS
    FROM ALLS
    GROUP BY 1
    ORDER BY 2 DESC
    Run a query to Download Data