m0rt3zaRealms - DAO's stats comparison
Updated 2023-04-13
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
31
›
⌄
SELECT COUNT(DISTINCT tx_id) as votes, COUNT(DISTINCT voter) as voters, COUNT(DISTINCT proposal),
CASE
WHEN realms_id = 'DPiH3H3c7t47BMxqTxLsuPQpEC6Kne8GA9VXbxpnZxFE' THEN 'Mango'
WHEN realms_id = '3MMDxjv1SzEFQDKryT7csAvaydYtrgMAc3L9xL9CVLCg' THEN 'Serum'
WHEN realms_id = 'By2sVGZXwfQq6rAiAM3rNPJ9iQfb5e2QhnF4YjJ4Bip' THEN 'Grape'
WHEN realms_id = 'FiG6YoqWnVzUmxFNukcRVXZC51HvLr6mts8nxcm7ScR8' THEN 'Psy Finance'
WHEN realms_id = 'B1CxhV1khhj7n5mi5hebbivesqH9mvXr5Hfh2nD2UCh6' THEN 'MonkeDAO'
WHEN realms_id = 'Cdui9Va8XnKVng3VGZXcfBFF6XSxbqSi2XruMc7iu817'
OR realms_id = '2sEcHwzsNBwNoTM1yAXjtF1HTMQKUAXf8ivtdpSpo9Fv' THEN 'Metaplex'
WHEN realms_id = '78TbURwqF71Qk4w1Xp6Jd2gaoQb6EC7yKBh5xDJmq6qh' THEN 'Jet'
WHEN realms_id = '7sf3tcWm58vhtkJMwuw2P3T6UBX7UE5VKxPMnXJUZ1Hn' THEN 'Solend'
WHEN realms_id = '6orGiJYGXYk9GT2NFoTv2ZMYpA6asMieAqdek4YRH2Dn' THEN 'The imperium of Rain'
WHEN realms_id = '7oB84bSuxv9AH1iRdMp5nFLwpQApv8Yo9s1gGmDkHtSP' THEN 'Synthetify'
END AS dao_name
FROM solana.core.fact_proposal_votes
WHERE succeeded = TRUE
AND realms_id IN
('DPiH3H3c7t47BMxqTxLsuPQpEC6Kne8GA9VXbxpnZxFE', --mango dao
'3MMDxjv1SzEFQDKryT7csAvaydYtrgMAc3L9xL9CVLCg', --serum
'78TbURwqF71Qk4w1Xp6Jd2gaoQb6EC7yKBh5xDJmq6qh', -- jet
'7sf3tcWm58vhtkJMwuw2P3T6UBX7UE5VKxPMnXJUZ1Hn', -- solend
'FiG6YoqWnVzUmxFNukcRVXZC51HvLr6mts8nxcm7ScR8', -- psy finance
'B1CxhV1khhj7n5mi5hebbivesqH9mvXr5Hfh2nD2UCh6', -- monke dao
'Cdui9Va8XnKVng3VGZXcfBFF6XSxbqSi2XruMc7iu817', -- metaplex genesis
'2sEcHwzsNBwNoTM1yAXjtF1HTMQKUAXf8ivtdpSpo9Fv', -- metaplex foundation
'By2sVGZXwfQq6rAiAM3rNPJ9iQfb5e2QhnF4YjJ4Bip', -- grape
'6orGiJYGXYk9GT2NFoTv2ZMYpA6asMieAqdek4YRH2Dn', -- the imperium rain
'7oB84bSuxv9AH1iRdMp5nFLwpQApv8Yo9s1gGmDkHtSP' -- synthetify
)
GROUP BY dao_name
Run a query to Download Data