t1 AS (SELECT COUNT(DISTINCT FROM_ADDRESS) AS ALL_ETH_USERS FROM ethereum.core.fact_transactions),

t2 AS (SELECT COUNT(DISTINCT SIGNERS[0]) AS ALL_SOL_USERS FROM solana.core.fact_transactions),

t3 AS (SELECT COUNT(DISTINCT VOTER) AS ETH_VOTERS FROM ethereum.core.ez_snapshot),

t4 AS (SELECT COUNT(DISTINCT VOTER) AS SOL_VOTERS FROM solana.core.fact_proposal_votes WHERE GOVERNANCE_PLATFORM = 'realms' AND SUCCEEDED = 'TRUE')

SELECT (ETH_VOTERS/ALL_ETH_USERS)*100, (SOL_VOTERS/ALL_SOL_USERS)*100

FROM t1,t2,t3,t4