Ali3NTop 10 Terra Proposals With Most Number of Votes
Updated 2023-02-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
›
⌄
with maintable as (
select 'Cosmos' as chain,
proposal_id::string,
count (distinct tx_id) as Votes_Count,
count (distinct voter) as Voters_Count
from cosmos.core.fact_governance_votes
where tx_succeeded = 'TRUE'
group by 1,2
union ALL
select 'Osmosis' as chain,
proposal_id::string,
count (distinct tx_id) as Votes_Count,
count (distinct voter) as Voters_Count
from osmosis.core.fact_governance_votes
where tx_succeeded = 'TRUE'
group by 1,2
union ALL
select 'Terra' as chain,
proposal_id::string,
count (distinct tx_id) as Votes_Count,
count (distinct voter) as Voters_Count
from terra.core.fact_governance_votes
where tx_succeeded = 'TRUE'
group by 1,2)
select * from maintable
where chain = 'Terra'
order by votes_count desc
limit 10
Run a query to Download Data