with snapshot as (select space_id as DAO,count (distinct id) as Votes,count (distinct voter) as Voters, count (distinct proposal_id) as Proposals from ethereum.core.ez_snapshot

group by 1), realms as ( select realms_id as DAO, count (distinct tx_id) as Votes, count (distinct voter) as Voters, count (distinct proposal) as Proposals from solana.core.fact_proposal_votes

where governance_platform = 'realms' group by 1) select 'Snapshot' as type_snapshot_realms, avg(votes), avg (voters), avg (proposals) from snapshot

Union ALL select 'Realms' as type_snapshot_realms, avg(votes), avg (voters), avg (proposals) from realms