eslamis-darkatavg and total 8
Updated 2022-09-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with average as (select avg(CURRENT_BAL) as number
from ethereum.core.ez_current_balances join ethereum.core.fact_event_logs b on user_address = origin_from_address
where symbol = 'ETH' and TOKEN_NAME='Native Ether' and lower(b.contract_address) = lower('0x881D40237659C251811CEC9c364ef91dC08D300C')
)
,
total as (select sum(CURRENT_BAL) as number
from ethereum.core.ez_current_balances join ethereum.core.fact_event_logs b on user_address = origin_from_address
where symbol = 'ETH' and TOKEN_NAME='Native Ether' and lower(b.contract_address) = lower('0x881D40237659C251811CEC9c364ef91dC08D300C')
)
select *,'average' as which
from average
UNION
select *,'total' as which
from total
Run a query to Download Data