distinct project_name as collection,

count (distinct purchaser) as num_buyers,

sum(sales_amount) as total_volume

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

where marketplace = 'coral cube'

and block_timestamp >= '2022-09-22'

and succeeded = 'TRUE'

group by collection

order by 3 DESC

limit 10