eslamis-darkatusers 1
Updated 2022-09-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with others as (select count(distinct ORIGIN_FROM_ADDRESS) as number_of_users
from ethereum.core.fact_event_logs
where lower(contract_address) != lower('0x881D40237659C251811CEC9c364ef91dC08D300C') )
,
metamask as (select count(distinct ORIGIN_FROM_ADDRESS) as number_of_userss
from ethereum.core.fact_event_logs
where lower(contract_address) = lower('0x881D40237659C251811CEC9c364ef91dC08D300C') )
select number_of_users,'other_users' as number
from others
UNION
select number_of_userss , 'metamask_users' as number
from metamask
Run a query to Download Data