select

*

from ethereum.core.ez_nft_sales

where buyer_address != '0x0000000000000000000000000000000000000000'

and seller_address != '0x0000000000000000000000000000000000000000'

and event_type= 'sale'

and price_usd != 0

and tx_hash != '0x92488a00dfa0746c300c66a716e6cc11ba9c0f9d40d8c58e792cc7fcebf432d0'

and nft_address = '0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb'

select

buyer_address as "Buyer",

sum(price_usd) as "Sales Volume (USD)",

count(distinct tx_hash) as "Number of Purchases"

from cryptopunks_total_transactions

group by "Buyer"

order by "Sales Volume (USD)" desc

limit 10