with maintable as (
select 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 tokenid) as Tokens_Count,
count (distinct nft_address) as Collections_Count,
count (distinct platform_name) as Platforms_Count,
sum (price_usd) as Total_Sales_Volume,
avg (price_usd) as Average_Sales_volume,
median (price_usd) as median_sale_volume,
min (price_usd) as minimum_sale_volume,
max (price_usd) as maximum_sale_volume,
sum (tx_fee_usd) as Total_TX_Fee,
avg (tx_fee_usd) as Average_TX_Fee,
median (tx_fee_usd) as Median_TX_Fee
from ethereum.core.ez_nft_sales
where origin_to_address = '0xef1c6e67703c7bd7107eed8303fbe6ec2554bf6b'
group by 1)
select 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'
else 'More Than 10 Trades' end as type,
count (distinct seller_address) as Users_count
from maintable
group by 1