select initcap(platform_name) as Marketplace,

buyer_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 sales_count = 1 then '1 Trade'

when sales_count > 1 and sales_count <= 5 then '2 - 5 Trades'

when sales_count > 5 and sales_count <= 10 then '6 - 10 Trades'

when sales_count > 10 and sales_count <= 25 then '11 - 25 Trades'

when sales_count > 26 and sales_count <= 50 then '26 - 50 Trades'

else 'More Than 50 Trades' end as type,

count (distinct buyer_address) as Users_count

from maintable

group by 1,2