jackguySnapshot DAO Activity Tool 3
    Updated 2023-03-13
    with tab1 as (
    SELECT
    count(*) as votes,
    count(DISTINCT voter) as voters,
    count(DISTINCT proposal_id) as proposals,
    count(*) / count(DISTINCT proposal_id) as average_votes_per_proposal
    FROM ethereum.core.ez_snapshot
    WHERE space_id LIKE '{{dao}}'
    --GROUP BY 1,2
    )
    SELECT *

    from tab1
    Run a query to Download Data