SELECT
coalesce(address_name,project_name,'Not Labeled Collections') as Collection,
COUNT(DISTINCT TX_ID) AS number_of_sales,
sum(SALES_AMOUNT) AS total_sales_in_SOL,
COUNT(DISTINCT PURCHASER) AS unique_purchaser,
COUNT(DISTINCT SELLER) AS unique_seller
FROM solana.core.fact_nft_sales S
left join solana.core.dim_nft_metadata M on S.mint = M.mint
left join solana.core.dim_labels L on S.mint = L.address
WHERE MARKETPLACE = 'coral cube'
and SUCCEEDED = TRUE
AND COLLECTION <> 'Not Labeled Collections'
group by Collection
order by total_sales_in_SOL DESC
LIMIT 10