token_name as NFT_name,

count (distinct tx_id) as tx_vol,

count (distinct purchaser) as buyer_count,

sum (sales_amount) as sales,

row_number() over (order by sales desc) as rank

from solana.core.fact_nft_sales a

left outer join solana.core.dim_nft_metadata b on a.mint = b.mint

where marketplace = 'hyperspace'

AND token_name is not null

and succeeded='true'

group by 1

order by sales DESC

limit 10