sinahosseinzadehUntitled Query
    Updated 2022-08-31
    with tb_1 as (
    select 'Realms' as platform ,count(distinct program_name) as daos , count(distinct voter) as voters,count(distinct proposal) as proposals
    from solana.core.fact_proposal_votes
    where governance_platform like 'realms'
    ),
    tb_2 as (
    select 'Snapshot' as platform,count(distinct space_id) daos , count(distinct voter) as voters,count(distinct proposal_id) as proposals
    from ethereum.core.ez_snapshot
    ),
    tb_3 as (
    select * from tb_1 union select *
    from tb_2
    )

    select platform , voters / DAOs as votes_per_dao , voters / proposals as voters_per_proposal , proposals / DAOs as avg_proposals_per_dao
    from tb_3
    Run a query to Download Data