buyer_address as purchaser,

count(distinct(tx_hash)) as sales_count,

sum(price_usd) as volume_usd,

avg(price_usd) as volume_avg,

median(price_usd) as volume_median,

count(distinct(seller_address)) as sellers_count,

(sales_count / sellers_count) as tx_per_seller,

(volume_usd / sellers_count) as volume_per_seller

from ethereum.core.ez_nft_sales

where block_timestamp >= '2022-11-01'

and platform_name = '{{ market_place }}'

group by purchaser

having volume_usd > 0

order by 2 desc

limit 10