AshlyCryptoUntitled Query
Updated 2023-02-16
999
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
34
35
36
›
⌄
with
votes as (
select
PROPOSAL_ID,
VOTE_OPTION_TEXT,
count(DISTINCT TX_ID) as total_votes,
round(
(total_votes * 100) / SUM(total_votes) OVER (
partition by
PROPOSAL_ID
),
2
) as perc
from
terra.core.fact_governance_votes
where
TX_SUCCEEDED
group by
1,
2
),
votes_df as (
select
PROPOSAL_ID,
sum(TOTAL_VOTES) as TOTAL_VOTES,
sum("'Yes'") as Yes,
sum("'No'") as No,
sum("'Abstain'") as Abstain,
sum("'NoWithVeto'") as NoWithVeto
from
(
SELECT
*
FROM
votes PIVOT (
SUM(perc) FOR VOTE_OPTION_TEXT IN ('Yes', 'No', 'Abstain', 'NoWithVeto')
Run a query to Download Data