with tab1 as (select seller_address as Seller, count(tx_hash) as Sales_Count, case
when Sales_count=1 then 'Sales Count=1'
when Sales_count>1 and Sales_count<=10 then '1<Sales Count<=10'
when Sales_count>10 and Sales_count<=100 then '10<Sales Count<=100'
when Sales_count>100 then 'Sales Volume>100'
end as Group_
from ethereum.core.ez_nft_sales
where project_name='cryptopunks'
and block_timestamp::date>='2021-01-01'
group by 1)
select Group_, count(seller)
from tab1
group by 1