FatemeTheLady2: R vs S
Updated 2022-08-31
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
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