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