ramishoowUntitled Query
Updated 2022-12-11
9
1
2
3
›
⌄
SELECT s.rarity ,COUNT(DISTINCT ramishow.tx_group_id) FROM algorand.nft.ez_nft_sales_fifa ramishow JOIN algorand.nft.ez_nft_metadata_fifa s
--SELECT s.rarity ,COUNT(DISTINCT ramishow.tx_group_id) FROM algorand.nft.ez_nft_sales_fifa ramishow JOIN algorand.nft.ez_nft_metadata_fifa s
ON ramishow.nft_asset_id = s.nft_asset_id WHERE ramishow.sale_type = 'secondary' AND s.drop_number = 1 GROUP BY 1 --1
Run a query to Download Data