to_address as user_address,

SUM(amount) as amounts

from base.core.ez_token_transfers

where from_address = '0xeb7d383b0c77ea0bed28b42d0c288f9071bd8a7a'

and contract_address = '0x98d0baa52b2d063e780de12f615f963fe8537553'

and origin_function_signature = '0x69659658'

group by 1

select

(case

when amounts < 100 then 'Less Than 100 Tokens'

when amounts >= 100 and amounts <500 then 'Between 100 and 500 Tokens'

when amounts >= 500 and amounts <1000 then 'Between 500 and 1000 Tokens'

when amounts >= 1000 and amounts <5000 then 'Between 1000 and 5K Tokens'

when amounts >= 5000 and amounts <10000 then 'Between 5K and 10K Tokens'

when amounts >= 10000 then 'More Than 10K Tokens'

END ) as category,

count(user_address) as users,

SUM(amounts) as amounts

from datas

group by 1