0xHaM-dGovernance
    Updated 2024-04-16
    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