distinct project_name,

count(distinct tx_id) as sales,

count(distinct purchaser) as buyers,

sum(sales_amount) as volume

from solana.core.fact_nft_sales t1

join solana.core.dim_nft_metadata t2 on t1.mint = t2.mint

where marketplace = 'hyperspace'

group by 1 order by 3 DESC

limit 10