select top 10
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