select voter,

count (distinct id) as Votes

from ethereum.core.ez_snapshot

group by 1),

realms as (

select voter,

count (distinct tx_id) as Votes

from solana.core.fact_proposal_votes

where governance_platform = 'realms'

group by 1)

select 'Snapshot' as type, avg(votes) as average_votes from snapshot

Union ALL

select 'Realms' as type, avg(votes) as average_votes from realms