upper(marketplace) "Platform",

count(distinct tx_id) "Transaction Count",

sum(sales_amount) "Sales Amount",

count(distinct purchaser) "Unique Purchasers",

count(distinct seller) "Unique Sellers"

from solana.core.fact_nft_sales

where 1 = 1

and succeeded = 1

and marketplace in ('hyperspace', 'coral cube')

group by marketplace

order by 1 desc