distinct project_name,

count(distinct tx_id) as sales_count,

count(distinct purchaser) as buyers_count,

sum(sales_amount) as sales_volume

from solana.core.fact_nft_sales t1

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

where marketplace = 'hyperspace'

and block_timestamp >= '2022-09-22'

group by 1 order by 2 desc

limit 10