FatemeTheLady2: R vs S
    Updated 2022-08-31
    with
    Snapshot as(
    select 'Snapshot' as Platform,
    (count(distinct VOTER) / (select count (distinct from_address) from ethereum.core.fact_transactions))*100 as user_market_share
    from ethereum.core.ez_snapshot)
    ,
    Realms as(
    select 'Realms' as Platform,
    (count(distinct VOTER) / (select count (distinct SIGNERS[0]) from solana.core.fact_transactions))*100 as user_market_share
    from solana.core.fact_proposal_votes
    where governance_platform = 'realms')

    select * from Snapshot
    union
    select * from Realms
    Run a query to Download Data