0-MIDstatis withdr with
Updated 2023-08-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with tab1 as (
select
count(distinct FROM_ADDRESS) as withdrawers
,count(distinct tx_hash) as with_count
,sum(ETH_VALUE) as "ETH VALUE"
from base.core.fact_transactions
where TO_ADDRESS in('0x80c67432656d59144ceff962e8faf8926599bcf8','0xe4edb277e41dc89ab076a1f049f4a3efa700bce8','0xd9d74a29307cc6fc8bf424ee4217f1a587fbc8dc')
)
select
with_count/withdrawers as avg
from tab1
Run a query to Download Data