0-MIDuser dis
Updated 2024-01-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with tab1 as (
select ORIGIN_FROM_ADDRESS
,count(distinct TX_HASH) as bridges
from ethereum.defi.ez_bridge_activity
where BLOCK_TIMESTAMP>='2023-01-01' and BLOCK_TIMESTAMP<='2023-12-31'
and DESTINATION_CHAIN='zksync era mainnet'
group by 1 )
select bridges
,count(distinct ORIGIN_FROM_ADDRESS) as bridgers
from tab1
group by 1
QueryRunArchived: QueryRun has been archived