with tab1 as (select from_address, sum(tx_fee), case
when sum(tx_fee)<=0.001 then 'Fee<=0.001 ETH'
when sum(tx_fee)>0.001 and sum(tx_fee)<=0.01 then '0.001<Fee<=0.01 ETH'
when sum(tx_fee)>0.01 and sum(tx_fee)<=0.1 then '0.01<Fee<=0.1 ETH'
when sum(tx_fee)>0.1 and sum(tx_fee)<=0.5 then '0.1<Fee<=0.5 ETH'
when sum(tx_fee)>0.5 and sum(tx_fee)<=1 then '0.5<Fee<=1 ETH'
when sum(tx_fee)>1 then 'Fee>1 ETH'
end as "Class"
from blast.core.fact_transactions
where status='SUCCESS' and block_timestamp::date>='2024-02-29'
group by 1)
select "Class", count(distinct from_address) as "Users Count"
from tab1
group by 1