upper(marketplace) "Platform",

project_name "Project",

count(distinct tx_id) "Transaction Count",

sum(sales_amount) "Sales Amount",

count (distinct token_id) "NFT Count"

from solana.core.fact_nft_sales a

inner join solana.core.dim_nft_metadata b

where 1 = 1

and a.mint = b.mint

and succeeded = 1

and marketplace in ('hyperspace')

group by 1, 2

order by 4 desc

limit 10