Afonso_DiazUntitled Query
Updated 2023-01-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with
t1 as (
select
voter,
count(distinct proposal_id) as proposals_count,
count(distinct(block_timestamp::date)) as active_days
from terra.core.fact_governance_votes
where proposal_id >= 3619
group by voter
)
select
avg(proposals_count) as average_proposals_count,
avg(active_days) as average_active_days
from t1
Run a query to Download Data