select initcap(coalesce(address_name,project_name,null)) as Collection,
t1.mint,
count (distinct tx_id) as Sales_Count,
count (distinct purchaser) as Purchasers_Count,
sum (sales_amount) as Sales_Volume
from solana.core.fact_nft_sales t1 full outer join solana.core.dim_nft_metadata t2 on t1.mint = t2.mint
full outer join solana.core.dim_labels t3 on t1.mint = t3.address
where marketplace = 'hyperspace' and collection is not null
group by 1,2 having sales_count = 1
order by 5 DESC
limit 10