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