select initcap(platform_name) as Marketplace,

seller_address,

count (distinct tx_hash) as Sales_count,

count (distinct buyer_address) as Buyers_count,

count (distinct seller_address) as Sellers_count,

count (distinct nft_address) as Collections_Count,

count (distinct tokenid) as Tokens_Count,

sum (creator_fee_usd) as Total_Royalty_Fees,

avg (creator_fee_usd) as Average_Royalty_Fees,

median (creator_fee_usd) as Median_Royalty_Fees,

sum (price_usd) as Total_USD_Volume,

avg (price_usd) as Average_USD_Volume,

median (price_usd) as Median_USD_Volume,

min (price_usd) as Minimum_USD_Volume,

Max (price_usd) as Maximum_USD_Volume

from ethereum.core.ez_nft_sales

where block_timestamp >= '2022-10-19 04:49:47.000'

group by 1,2

order by 1)

select marketplace,

case when Total_USD_Volume < 10 then 'Less Than $10'

when Total_USD_Volume >= 10 and Total_USD_Volume < 100 then '$10 - $100'

when Total_USD_Volume >= 100 and Total_USD_Volume < 1000 then '$100 - $1000'

when Total_USD_Volume >= 1000 and Total_USD_Volume < 10000 then '$1000 - $10000'

when Total_USD_Volume >= 10000 and Total_USD_Volume < 100000 then '$10000 - $100000'

else 'More Than $100000' end as type,

count (distinct seller_address) as Users_count

from maintable

group by 1,2