select
buyer_address as "Buyer",
count(distinct tx_hash) as "Count of purchase",
Count(distinct project_name) as "Purchased collections",
round(sum(price_usd),2) as "Total purchase volume (USD)",
round(avg(price_usd),2) as "Average purchase price (USD)",
round(sum(TOTAL_FEES_USD),2) as "Total paid fee (USD)",
round("Total paid fee (USD)"/"Total purchase volume (USD)"*100,2) as "Share of paid fee (%)"
from avalanche.core.ez_nft_sales
group by 1
order by 4 DESC
limit 100