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