select

PROJECT_NAME as collection

,sum(PRICE_USD) as volume

,count(distinct TOKENID) as nft_sold

,count(distinct BUYER_ADDRESS) as buyers

,count(distinct SELLER_ADDRESS) as sellers

,count(distinct TX_HASH) as sell_count

from bsc.nft.ez_nft_sales

where PROJECT_NAME is not null

group by 1

order by 2 desc

limit 10