nitsUntitled Query
Updated 2022-11-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
SELECT
proposal_id,
description,
Concat(
description, ' (', proposal_id, ' )'
) AS vote_desc,
Count(DISTINCT voter) AS no_of_voters,
Count(DISTINCT tx_id) AS no_of_txns,
Sum(vote_weight) AS tot_voting_power,
(tot_voting_power / no_of_voters) AS avg_voting_power
FROM
osmosis.core.fact_governance_votes
LEFT OUTER JOIN osmosis.core.dim_vote_options ON vote_id = vote_option
WHERE
proposal_id = 362
AND tx_status = 'SUCCEEDED'
GROUP BY
proposal_id,
description,
vote_desc
Run a query to Download Data