select space_id, count(distinct proposal_id) as number_of_proposals, count(distinct voter) as voters,voters/number_of_proposals as average_number_voters_proposal from ethereum.core.ez_snapshot
where 1=1
and space_id in ('vote.metricsdao.eth','biconomy.eth')
-- and choices ilike '%veto%'
group by space_id
-- and PROPOSAL_END_TIME <= CURRENT_DATE