0xHaM-dGovernance
Updated 2024-04-16Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
SELECT
date_trunc('week', BLOCK_TIMESTAMP)::date as date,
CASE
WHEN VOTE_OPTION = 1 THEN 'YES'
WHEN VOTE_OPTION = 2 THEN 'ABSTAIN'
WHEN VOTE_OPTION = 3 THEN 'NO'
WHEN VOTE_OPTION = 4 THEN 'NO WITH VETO'
END as vote_type,
CASE
WHEN voter in (SELECT DELEGATOR_ADDRESS FROM axelar.gov.fact_staking) THEN 'Staker'
ELSE 'Regular' END as voter_type,
voter_type || ': ' || vote_type as vot_option,
count(DISTINCT tx_id) as vote_cnt,
count(DISTINCT voter) as voter_cnt,
count(DISTINCT PROPOSAL_ID) as prop_cnt
FROM axelar.gov.fact_governance_votes
GROUP by 1,2,3,4
order by 1
QueryRunArchived: QueryRun has been archived