mlhTotal count of votes
    Updated 2023-01-12
    with tab1 as (
    SELECT
    proposal_id as p_id,
    PROPOSAL_TYPE as p_type,
    block_timestamp as p_time
    FROM terra.core.fact_governance_submit_proposal
    )

    SELECT COUNT(DISTINCT VOTER) as voters,
    COUNT(DISTINCT TX_ID) as votes
    FROM terra.core.fact_governance_votes
    LEFT outer JOIN tab1
    ON p_id = proposal_id
    WHERE p_time is not NULL
    Run a query to Download Data