PROJECT_NAME as NFT_project,

count(distinct tx_hash) as number_of_sales,

count(distinct buyer_ADDRESS) as number_of_buyers,

count(distinct SELLER_ADDRESS) as number_of_seller,

sum(PRICE_USD) as Volume_in_USD,

avg(PRICE_USD) as Average_USD_sale_price_in_USD,

min(PRICE_USD) as min_USD_price,

max(PRICE_USD) as max_USD_price,

sum(CREATOR_FEE_USD) as creator_fee_in_total

from base.nft.ez_nft_sales

where block_timestamp <= current_date - 1

and PRICE_USD>0 and PROJECT_NAME is not null

group by NFT_project

order by number_of_sales desc

limit 10