case

when ETH_VALUE>0 and ETH_VALUE<0.5 then 'Below 0.5 ETH'

when ETH_VALUE>=0.5 and ETH_VALUE<1 then '0.5~1 ETH'

when ETH_VALUE>=1 and ETH_VALUE<=2 then '1~2 ETH'

when ETH_VALUE>2 and ETH_VALUE<=5 then '2~5 ETH'

when ETH_VALUE>5 and ETH_VALUE<=7 then '5~7 ETH'

when ETH_VALUE>7 and ETH_VALUE<=10 then '7~10 ETH'

when ETH_VALUE>10 then 'Up To 10 ETH' end as dis_volume

,count(distinct tx_hash) as "WITHDRAW COUNT"

from base.core.fact_transactions

where TO_ADDRESS in('0x80c67432656d59144ceff962e8faf8926599bcf8','0xe4edb277e41dc89ab076a1f049f4a3efa700bce8','0xd9d74a29307cc6fc8bf424ee4217f1a587fbc8dc')

group by 1