nft_collection,

round(sum(price),2) as total_sales_volume,

count(distinct buyer) as no_of_buyers,

round(avg(price),2) as avg_sales_volume,

count(distinct tx_id) as no_of_nft_sales

FROM flow.core.ez_nft_sales

WHERE buyer in (

SELECT

distinct buyer

FROM flow.core.ez_nft_sales

WHERE nft_collection like '%A.329feb3ab062d289.RaceDay_NFT%'

)

GROUP BY nft_collection

order by no_of_buyers desc

limit 10