latsanCopy of Untitled Query
    Updated 2023-01-26
    SELECT block_timestamp::date as time, -- date_trunc('day', block_timestamp) as time,
    proposal_id,
    CASE
    WHEN proposal_id = 3619 THEN 'CommunityPoolSpend'
    WHEN proposal_id = 3796 THEN 'SoftwareUpgrade'
    else 'Nil'
    END as proposal_type,
    COUNT(DISTINCT voter) as voters,
    COUNT(DISTINCT tx_id) as vote_count
    FROM terra.core.fact_governance_votes
    WHERE proposal_id in ('3619','3796')
    GROUP by 1,2,3
    order by 1 ASC
    Run a query to Download Data