FROM_ADDRESS ,

count(distinct tx_hash) transactions

from base.core.fact_transactions

where STATUS ='SUCCESS'

group by 1

order by 1

select case when transactions =1 then 'One transaction'

when transactions BETWEEN 2 and 5 then '2 - 5 Transactions'

when transactions BETWEEN 5 and 10 then '5 - 10 Transactions'

when transactions BETWEEN 10 and 20 then '10 - 20 Transactions'

when transactions BETWEEN 20 and 50 then '20 - 50 Transactions'

when transactions BETWEEN 50 and 100 then '50 - 100 Transactions'

when transactions BETWEEN 100 and 200 then '100 - 200 Transactions'

when transactions BETWEEN 200 and 500 then '200 - 500 Transactions'

when transactions BETWEEN 500 and 1000 then '500 - 1000 Transactions'

else 'Greater than 1K transactions'

end range ,

count (FROM_ADDRESS) num_wallets

from wallet

group by 1