buyer_address,

sum(price_usd) USD_Amount,

COUNT(DISTINCT tx_hash) as purchases

from ethereum.core.ez_nft_sales left outer join ethereum.core.dim_labels

on nft_address = address

where label = 'cryptopunks'

and price_usd is not null

group by 1

order by 2 DESC

limit 10