Label AS Collection,

MARKETPLACE,

count(distinct PURCHASER) AS "unique buyers number",

rank() over (partition by MARKETPLACE order by "unique buyers number" 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