(SELECT sales.*, dim.nft_asset_name, SPLIT(dim.nft_asset_name, '#') AS card_data, card_data[1] AS card_supply, dim.name, dim.application_id, dim.drop_number,

dim.drop_name, dim.item_no, dim.editions, dim.rarity, dim.world_cup_type, dim.year, dim.event_type, dim.player

FROM algorand.nft.ez_nft_sales_fifa sales

JOIN algorand.nft.ez_nft_metadata_fifa dim

ON sales.nft_asset_id = dim.nft_asset_id),

rarity_mints AS

SELECT COUNT(tx_group_id) AS "Total Mints", drop_name, rarity

FROM fifaplus_data

WHERE sale_type = 'mint'

AND drop_name IN ('genesis', 'archives', 'south american flair', 'archives 2')

-- AND NOT (drop_name = 'archives 2' AND rarity = 'Iconic')

GROUP BY drop_name, rarity

ORDER BY drop_name, rarity

),

total_mints_rarity AS

(SELECT SUM(SPLIT(nft_asset_name, '#')[1]) AS "Total Supply" , drop_name, rarity

FROM algorand.nft.ez_nft_metadata_fifa

WHERE drop_name IN ('genesis', 'archives', 'south american flair', 'archives 2')

-- AND NOT (drop_name = 'archives 2' AND rarity = 'Iconic')

GROUP BY drop_name, rarity

ORDER BY drop_name, rarity),

total_mints_collection AS

(SELECT SUM(SPLIT(nft_asset_name, '#')[1]) AS "Total Supply" , drop_name

FROM algorand.nft.ez_nft_metadata_fifa

WHERE drop_name IN ('genesis', 'archives', 'south american flair', 'archives 2')

-- AND NOT (drop_name = 'archives 2' AND rarity = 'Iconic')

GROUP BY drop_name

ORDER BY drop_name),

total_minted_collection AS

(SELECT SUM("Total Mints") AS "Total Mints", drop_name