How many percent of the wallets that were familiar with realms have participated in each of these dao's.
rezarwzHow many percent of the wallets that were familiar with realms have participated in each of these dao's.
Updated 2022-08-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
›
⌄
with base as(
SELECT
COUNT(DISTINCT voter) as number_of_member,
CASE
when REALMS_ID = 'DPiH3H3c7t47BMxqTxLsuPQpEC6Kne8GA9VXbxpnZxFE' then 'Mango'
when REALMS_ID = 'By2sVGZXwfQq6rAiAM3rNPJ9iQfb5e2QhnF4YjJ4Bip' then 'Grape'
when REALMS_ID = 'FiG6YoqWnVzUmxFNukcRVXZC51HvLr6mts8nxcm7ScR8' then 'Psy Finance'
when REALMS_ID = '7sf3tcWm58vhtkJMwuw2P3T6UBX7UE5VKxPMnXJUZ1Hn' then 'Solend'
when REALMS_ID = 'B1CxhV1khhj7n5mi5hebbivesqH9mvXr5Hfh2nD2UCh6' then 'MonkeDAO'
when REALMS_ID = 'Cdui9Va8XnKVng3VGZXcfBFF6XSxbqSi2XruMc7iu817' then 'Metaplex Genesis'
when REALMS_ID = '2sEcHwzsNBwNoTM1yAXjtF1HTMQKUAXf8ivtdpSpo9Fv' then 'Metaplex Foundation'
when REALMS_ID = '78TbURwqF71Qk4w1Xp6Jd2gaoQb6EC7yKBh5xDJmq6qh' then 'Jet'
when REALMS_ID = '3MMDxjv1SzEFQDKryT7csAvaydYtrgMAc3L9xL9CVLCg' then 'Serum'
when REALMS_ID = '6orGiJYGXYk9GT2NFoTv2ZMYpA6asMieAqdek4YRH2Dn' then 'The Imperium of Rain'
when REALMS_ID = '7oB84bSuxv9AH1iRdMp5nFLwpQApv8Yo9s1gGmDkHtSP' then 'Synthetify'
else 'We dont want it'
End as DAO_NAME
FROM solana.core.fact_proposal_votes
WHERE DAO_NAME!='We dont want it' and SUCCEEDED='TRUE' and GOVERNANCE_PLATFORM='realms'
GROUP BY DAO_NAME),
total as(
SELECT
COUNT(DISTINCT voter) as total_number_of_member
FROM solana.core.fact_proposal_votes
WHERE SUCCEEDED='TRUE' and GOVERNANCE_PLATFORM='realms'
)
SELECT
(number_of_member/total_number_of_member*100) as Percentage_ratio,
DAO_NAME
from base ,total
Run a query to Download Data