Sbhn_NPracial-violet
    Updated 2024-10-18
    with base as (select DISTINCT to_address,
    sum(amount_usd) as usd
    from avalanche.core.ez_native_transfers
    where from_address in ('0xf30efc3b5f98a3d71e280c0bc3bf49690cf73e85','0x875401b4e856f4e72dbec139370855ee52a0fa7f')
    group by 1)

    select case usd<100 then '10$ - 100$'
    when usd>=100 and usd<1000 then '100$ - 1000$'
    else 'More Than 1000$' end as splitter,
    count(DISTINCT to_address) as receivers
    from base
    group by 1
    QueryRunArchived: QueryRun has been archived