ramishoowUntitled Query
    Updated 2022-12-11
    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