Afonso_DiazUntitled Query
Updated 2023-01-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with t as (
select
proposal_id,
count(distinct tx_id) as votes_count,
count(distinct voter) as voters_count,
sum(vote_weight) as vote_power
from terra.core.fact_governance_votes
where proposal_id >= 3619
group by proposal_id
)
select
avg(votes_count) as average_votes_count,
avg(voters_count) as average_voters_count
from t
Run a query to Download Data