sinahosseinzadehUntitled Query
Updated 2022-08-31
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
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