case

when amount <= 0.1 then 'less than 0.1ETH'

when amount >0.1 and amount <=1 then 'between 0.1-1 $ETH'

when amount >1 and amount <=5 then 'between 1-5 $ETH'

when amount >5 and amount <=10 then 'between 5-10 $ETH'

when amount >10 and amount <=50 then 'between 10-50 $ETH'

when amount >50 and amount <=100 then 'between 50-100 $ETH'

else 'more than 100 ETH'

end as type ,

count(distinct from_address) as users

from ethereum.core.ez_native_transfers

where to_address = lower('0x1F75881DC0707b5236f739b5B64A87c211294Abb')

group by 1