0-MIDcount dis dep
Updated 2024-01-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with tab1 as (
select
TO_ADDRESS
,count(distinct tx_hash) as "DEPOSIT COUNT"
from base.core.fact_transactions
where FROM_ADDRESS in('0x80c67432656d59144ceff962e8faf8926599bcf8','0xe4edb277e41dc89ab076a1f049f4a3efa700bce8','0xd9d74a29307cc6fc8bf424ee4217f1a587fbc8dc')
group by 1)
select "DEPOSIT COUNT"
,count(distinct TO_ADDRESS) as depositors
from tab1
group by 1
QueryRunArchived: QueryRun has been archived