select distinct project_name, count(distinct tx_id) as sales, 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 = 'coral cube'
group by 1 order by 2 DESC
limit 10