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),

ethereum2 as (

select count (distinct from_address) as ethereumusers from ethereum),

snapshot as (

select count (distinct voter) as Snapshot_Voters

from ethereum.core.ez_snapshot),

Solana as (

select count (distinct signers[0]) as Solana_Users

from solana.core.fact_transactions),

realms as (

select count (distinct voter) as Realms_Voters

from solana.core.fact_proposal_votes