select mint,

sum (sales_amount) as Total_Sales_Volume

from solana.core.fact_nft_sales

where succeeded ilike 'TRUE'

and marketplace ilike 'tensorswap'

group by 1

order by 2 DESC

limit 100)

select seller,

count (distinct tx_id) as Sales_count,

count (distinct Purchaser) as Buyers_count,

count (distinct Seller) as Sellers_count,

count (distinct mint) as NFTS_Count,

sum (sales_amount) as Sales_Volume

from solana.core.fact_nft_sales

where block_timestamp >= '2023-03-06'

and succeeded ilike 'TRUE'

and mint in (select distinct mint from topcollections)

and marketplace ilike 'tensorswap'

group by 1

order by 2 desc

limit 10