case when txs<=2 then '1 or 2 TXs'

when txs>2 and txs<=5 then '3 to 5 TXs'

when txs>5 and txs<=10 then '6 to 10 TXs'

when txs>10 and txs<=20 then '11 to 20 TXs'

when txs>20 and txs<=100 then '21 to 100 TXs'

when txs>100 and txs<=1000 then '101 to 1000 TXs'

when txs>1000 then '1000+ TXs'

else 'log' end as "TXs",

count(user) as "# of Users"

from

(select FROM_ADDRESS as user, count(*) as txs

from monad.testnet.fact_transactions

where TX_SUCCEEDED=true

group by 1)

group by 1

order by 2 desc