select
purchaser "Buyer",
upper(marketplace) "Platform",
count(distinct tx_id) "Transaction Count",
sum(sales_amount) "Sales Amount",
count(distinct seller) "Unique Sellers"
from solana.core.fact_nft_sales
where 1 = 1
and succeeded = 1
and marketplace in ('hyperspace')
group by 1, 2
order by 4 desc
limit 10