0-MIDcount dis with
Updated 2023-08-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with tab1 as (
select
FROM_ADDRESS
,count(distinct tx_hash) as "WITHDRAW COUNT"
from base.core.fact_transactions
where TO_ADDRESS in('0x80c67432656d59144ceff962e8faf8926599bcf8','0xe4edb277e41dc89ab076a1f049f4a3efa700bce8','0xd9d74a29307cc6fc8bf424ee4217f1a587fbc8dc')
group by 1)
select "WITHDRAW COUNT"
,count(distinct FROM_ADDRESS) as withdrawers
from tab1
group by 1
Run a query to Download Data