with tab1 as (select tx_hash, case
when amount_usd<=1 then 'V<=1 USD'
when amount_usd>1 and amount_usd<=10 then '1<V<=10 USD'
when amount_usd>10 and amount_usd<=100 then '10<V<=100 USD'
when amount_usd>100 and amount_usd<=1000 then '100<V<=1k USD'
when amount_usd>1000 and amount_usd<=10000 then '1k<V<=10k USD'
when amount_usd>10000 and amount_usd<=100000 then '10k<V<=100k USD'
when amount_usd>100000 and amount_usd<=1000000 then '100k<V<=1M USD'
ELSE 'V>1M USD' end as "Class"
from arbitrum.defi.ez_lending_deposits
where platform='Silo' and event_name='Deposit')
select "Class", count(distinct tx_hash) as "Deposit Count"
from tab1
group by 1