with maintable as (with table1 as ((select tx_id, block_timestamp, MARKETPLACE, NFT_COLLECTION, NFT_ID, buyer, seller, currency, price, (price*1) as usd_amount, date(block_timestamp) as date0, hour(block_timestamp) as hour0, minute(block_timestamp) as min0 from flow.core.ez_nft_sales where TX_SUCCEEDED = true and currency != 'A.1654653399040a61.FlowToken') union (with tab1 as (select tx_id, block_timestamp, MARKETPLACE, NFT_COLLECTION, NFT_ID, buyer, seller, currency, price, date(block_timestamp) as date0, hour(block_timestamp) as hour0, minute(block_timestamp) as min0 from flow.core.ez_nft_sales where TX_SUCCEEDED = true and currency = 'A.1654653399040a61.FlowToken'), price as (select date(TIMESTAMP) as date1, hour(TIMESTAMP) as hour1, minute(TIMESTAMP) as min1, TOKEN_CONTRACT, PRICE_USD from flow.core.fact_prices where TOKEN_CONTRACT = 'A.1654653399040a61.FlowToken') select tx_id, block_timestamp, MARKETPLACE, NFT_COLLECTION, NFT_ID, buyer, seller, currency, price, (price*price_usd) as usd_amount, date(block_timestamp) as date0, hour(block_timestamp) as hour0, minute(block_timestamp) as min0 from tab1 inner join price on date1=date0 and hour1=hour0 and min1=min0)) select tx_id, block_timestamp, (select min(contract_name) from flow.core.dim_contract_labels where event_contract = marketplace) as marketplace, (select min(contract_name) from flow.core.dim_contract_labels where event_contract = nft_collection) as NFT_COLLECTION, NFT_ID, buyer, seller, (select min(contract_name) from flow.core.dim_contract_labels where event_contract = currency) as currency, price, usd_amount from table1) select case when usd_amount < 1 then '< $1' when usd_amount >= 1 and usd_amount < 2.5 then '$1 - $2.5' when usd_amount >= 2.5 and usd_amount < 5 then '$2.5 - $5' when usd_amount >= 5 and usd_amount < 10 then '$5 - $10' when usd_amount >= 10 and usd_amount < 25 then '$10 - $25' when usd_amount >= 25 and usd_amount < 50 then '$25 - $50' when usd_amount >= 50 and usd_amount < 100 then '$50 - $100' when usd_amount >= 100 and usd_amount < 200 then '$100 - $200' when usd_amount >= 200 and usd_amount < 400 then '$200 - $400' else '> $400' end as groups, count (*) as sales_count from maintable where NFT_COLLECTION = 'RaceDay_NFT' group by 1 order by 2 desc

[Flow] - RaceDay NFTs