Sbhn_NPracial-violet
Updated 2024-10-18
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
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