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