select space_id, count(distinct proposal_id) as number_of_proposals, max(QUORUM) as quoram from ethereum.core.ez_snapshot
where 1=1
and space_id in ('vote.metricsdao.eth','biconomy.eth','opcollective.eth')
group by space_id
-- having sum(voting_power) > quoram
-- and PROPOSAL_END_TIME <= CURRENT_DATE