case

when (event_inputs:value/1e6) < 10 then 'less than 10 usd'

when (event_inputs:value/1e6) >= 10 and (event_inputs:value/1e6) < 100 then 'between 10-100 usd'

when (event_inputs:value/1e6) >= 100 and (event_inputs:value/1e6) < 1000 then 'between 100-1000 usd'

when (event_inputs:value/1e6) >= 1000 and (event_inputs:value/1e6) < 10000 then 'between 1000-10000 usd'

when (event_inputs:value/1e6) >= 10000 and (event_inputs:value/1e6) < 100000 then 'between 10000-100000 usd'

when (event_inputs:value/1e6) >= 100000 then 'more than 100000 usd'

end as distribution,

count(distinct ORIGIN_FROM_ADDRESS) as user

from avalanche.core.fact_event_logs

where contract_address = '0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e'

and event_name = 'Transfer'

and block_timestamp >= '2022-07-01'

and TX_STATUS = 'SUCCESS'

group by 1