Label AS Collection,

MARKETPLACE,

sum(SALES_AMOUNT) AS "Sol Volume",

rank() over (partition by MARKETPLACE order by "Sol Volume" desc) as rank

from solana.core.fact_nft_sales

inner join solana.core.dim_labels on address=mint

where MARKETPLACE in ('hyperspace','coral cube') and SUCCEEDED='TRUE'

group by 1,2 qualify rank <=10