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