Alexayoverall_stats
    Updated 2022-08-30
    with snapshot as ( select 'Snapshot' as platform, count (distinct id) as votes, count (distinct voter) as voters,
    count (distinct space_id) as daos, count (distinct proposal_id) as proposals
    from ethereum.core.ez_snapshot),
    realms as ( select 'Realms' as platform, count (distinct tx_id) as votes, count (distinct voter) as voters,
    count (distinct realms_id) as daos, count (distinct proposal) as proposals
    from solana.core.fact_proposal_votes
    where governance_platform = 'realms')

    select * from snapshot
    Union ALL
    select * from realms

    Run a query to Download Data