SELECT BUYER_ADDRESS as "Buyer",

COUNT(*) AS "NFTs bought",

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

avg(price_usd) as "Average NFT price"

FROM base.nft.ez_nft_sales

where project_name='based punks'

GROUP BY 1

ORDER BY 2 DESC

LIMIT 10