sherwanxA3
Updated 2022-11-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with
main as (
select
DISTINCT SENDER,
count(BLOCK_ID) as TRANSACTIONS
from axelar.core.fact_transfers
where TRANSFER_TYPE = 'IBC_TRANSFER_IN'
and TX_SUCCEEDED = 'TRUE'
GROUP by 1
order by 2 DESC
)
select
case
when (TRANSACTIONS) <= 1 then 'low than 1 bridge'
when (TRANSACTIONS) > 1 and (TRANSACTIONS) < 10 then 'between 1 - 10 bridge'
when (TRANSACTIONS) >= 10 and (TRANSACTIONS) < 100 then 'between 10 - 100 bridge'
when (TRANSACTIONS) >= 100 then 'more than 100 bridge'
else 'null'
end as type,count(SENDER) from main GROUP by 1 order by 2 DESC
Run a query to Download Data