with snap_chains_users as (select distinct from_address from ethereum.core.fact_transactions union all select distinct from_address from avalanche.core.fact_transactions

union all select distinct from_address from arbitrum.core.fact_transactions union all select distinct from_address from gnosis.core.fact_transactions

union all select distinct from_address from optimism.core.fact_transactions union all select distinct from_address from bsc.core.fact_transactions union all

select distinct from_address from polygon.core.fact_transactions ),

total_snap_chains_users as ( select count (distinct from_address) as snap_users_count from snap_chains_users ), snap_users as (

select count (distinct voter) as Snapshot_Voters from ethereum.core.ez_snapshot ),

solana_chain_users as ( select count (distinct signers[0]) as solana_users_count from solana.core.fact_transactions ),

realms_users as ( select count (distinct voter) as Realms_Voters from solana.core.fact_proposal_votes where governance_platform = 'realms' )

select 'Snapshot' as name, (snapshot_voters/snap_users_count) * 100 from snap_users, total_snap_chains_users UNION

select 'Realms' as name, (realms_voters/solana_users_count) * 100 from realms_users, solana_chain_users