with tab1 as (

select

FROM_ADDRESS

from base.core.fact_transactions

where STATUS='SUCCESS'

and TO_ADDRESS='0x87a701770996b323560e332396b33839482e2641'

and BLOCK_TIMESTAMP::date>='2024-04-25'

select

case

when AMOUNT>0 and AMOUNT<10 then 'Below 10 op'

when AMOUNT>=10 and AMOUNT<=100 then '10~100 op'

when AMOUNT>100 and AMOUNT<=500 then '100~500 op'

when AMOUNT>500 and AMOUNT<=1000 then '500~1000 op'

when AMOUNT>1000 then 'Up to 1000 op' end as dis_volume

,count(distinct ORIGIN_FROM_ADDRESS) as jlp_holders

from optimism.core.ez_token_transfers

where ORIGIN_TO_ADDRESS='0x9a69d97a451643a0bb4462476942d2bc844431ce'

and CONTRACT_ADDRESS='0x4200000000000000000000000000000000000042'

and ORIGIN_FUNCTION_SIGNATURE='0x2e7ba6ef'

and ORIGIN_FROM_ADDRESS in (select FROM_ADDRESS from tab1)

group by 1