ramishoowUntitled Query
Updated 2022-12-11
9
1
2
3
›
⌄
SELECT s.rarity ,SUM(ramishow.total_sales_amount_usd) FROM algorand.nft.ez_nft_sales_fifa ramishow JOIN algorand.nft.ez_nft_metadata_fifa s
--SELECT s.rarity ,SUM(ramishow.total_sales_amount_usd)) 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--2