(select

initcap(coalesce(address_name,project_name,null)) as Collection,

count (distinct tx_id) as trr ,

sum (sales_amount) as amount

from solana.core.fact_nft_sales b full outer join solana.core.dim_nft_metadata a on b.mint = a.mint

full outer join solana.core.dim_labels c

on b.mint = c.address

where marketplace = 'hyperspace'

and collection is not null

group by 1

order by 2 DESC limit 10)

select * from a