select

'Snapshot' as platform,

count(distinct VOTER) as voters,

count(*) as votes,

count(distinct space_id) as daos,

voters/daos as voter_per_dao,

votes/daos as vote_per_dao,

count(distinct PROPOSAL_ID) as proposals,

votes/voters as votes_per_voter,

PROPOSALS/daos as proposals_per_dao

from ethereum.core.ez_snapshot

where VOTE_TIMESTAMP >= CURRENT_DATE-75 and VOTE_TIMESTAMP < CURRENT_DATE

union all

'Realms' as platform,

count(distinct PROPOSAL) as proposals,

count(distinct VOTER) as voters,

count(distinct TX_ID) as votes,

count(distinct realms_id ) as daos,

voters/daos as voter_per_dao,

votes/daos as vote_per_dao,

votes/voters as votes_per_voter,

PROPOSALS/daos as proposals_per_dao

from solana.core.fact_proposal_votes

where governance_platform = 'realms'

and BLOCK_TIMESTAMP >= CURRENT_DATE-75 and BLOCK_TIMESTAMP < CURRENT_DATE