select 'Hyperspace' as platform,

seller,

count (distinct tx_id) as Sales_Count,

count (distinct mint) as NFTS_Count,

sum (sales_amount) as Total_SOL_Volume

from solana.core.fact_nft_sales

where marketplace = 'hyperspace'

and succeeded = 'TRUE'

group by 1,2

union ALL

select 'Coral Cube' as platform,

seller,

count (distinct tx_id) as Sales_Count,

count (distinct mint) as NFTS_Count,

sum (sales_amount) as Total_SOL_Volume

from solana.core.fact_nft_sales

where marketplace = 'coral cube'

and succeeded = 'TRUE'

group by 1,2)

select seller,

sales_count,

from maintable

where platform = 'Coral Cube'

order by 3 desc

limit 5