Count(DISTINCT tx_hash) AS no_of_sale_txns,

Count(DISTINCT tokenid) AS no_of_nfts_sold,

Count(DISTINCT seller_address) AS no_of_sellers,

Sum(tx_fee_usd) AS total_fees_usd,

Avg(tx_fee_usd) AS avg_fees_usd,

Avg(price_usd) AS avg_sale_volume,

Sum(price_usd) AS total_volume

FROM ethereum.core.ez_nft_sales

WHERE project_name LIKE 'cryptopunks'

AND nft_address = '0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb'

AND price_usd IS NOT NULL

AND price_usd > 0

AND price IS NOT NULL

AND price > 0

AND event_type = 'sale'

GROUP BY wallet

ORDER BY total_volume DESC

limit 10