WITH props AS (
-- On Chain
SELECT
count(distinct proposal_id) as cnt
FROM ethereum.aave.ez_votes
UNION
-- Snapshot
SELECT
count(distinct proposal_id) as cnt
FROM ethereum.core.ez_snapshot
WHERE space_id = 'aave.eth'
)
SELECT
sum(cnt) as num_props
FROM props