hess5 Recent Proposals Results
Updated 2023-01-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with proposal as ( select min(block_timestamp) as date, voter
from terra.core.fact_governance_votes
group by 2)
,
new_voter as ( select DISTINCT voter
from proposal
where date >= '2022-11-19')
select vote_option_text, proposal_id::string as pro, count(DISTINCT(voter)) as total_voter
from terra.core.fact_governance_votes
where proposal_id in ('3796','3794','3619','3795','3665')
and voter in (select voter from new_voter)
group by 1,2
UNION
select vote_option_text, proposal_id::string as pro, count(DISTINCT(voter)) as total_voter
from terra.core.fact_governance_votes
where proposal_id in ('3796','3794','3619','3795','3665')
and voter not in (select voter from new_voter)
group by 1,2
Run a query to Download Data