Alexayusers %
    Updated 2022-08-31
    with eth_table 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),

    eth_user as ( select count (distinct from_address) as eth_users from eth_table),

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

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

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

    select 'Snapshot' as platform, 100*(snap_users/eth_users) from snap_user, eth_user
    UNION
    select 'Realms' as platform, 100*(realms_users/sol_users) from realms_user, sol_user

    Run a query to Download Data