project_name,

count(distinct(tx_id)) as txn_count,

sum(sales_amount) as total_sales_amount,

count(distinct (purchaser)) as buyer_count,

count(distinct seller) as seller_count

from solana.core.fact_nft_sales

join solana.core.dim_nft_metadata

using (mint)

where marketplace = 'hyperspace'

and succeeded = true

group by project_name

order by total_sales_amount desc