Ali3NNumber of Each Vote Choice on DAOs
Updated 2022-08-15
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
32
33
34
35
36
›
⌄
with Mango as (
select 'Mango' as DAO,
vote_choice,
count (distinct tx_id)
from solana.core.fact_proposal_votes
where realms_id = 'DPiH3H3c7t47BMxqTxLsuPQpEC6Kne8GA9VXbxpnZxFE' and SUCCEEDED = 'TRUE' group by vote_choice),
Grape as (
select 'Grape' as DAO,
vote_choice,
count (distinct tx_id)
from solana.core.fact_proposal_votes
where realms_id = 'By2sVGZXwfQq6rAiAM3rNPJ9iQfb5e2QhnF4YjJ4Bip' and SUCCEEDED = 'TRUE' group by vote_choice),
PsyFinance as (
select 'PSY Finance' as DAO,
vote_choice,
count (distinct tx_id)
from solana.core.fact_proposal_votes
where realms_id = 'FiG6YoqWnVzUmxFNukcRVXZC51HvLr6mts8nxcm7ScR8' and SUCCEEDED = 'TRUE' group by vote_choice),
Solend as (
select 'Solend' as DAO,
vote_choice,
count (distinct tx_id)
from solana.core.fact_proposal_votes
where realms_id = '7sf3tcWm58vhtkJMwuw2P3T6UBX7UE5VKxPMnXJUZ1Hn' and SUCCEEDED = 'TRUE' group by vote_choice),
MonkeDAO as (
select 'MonkeDAO' as DAO,
vote_choice,
count (distinct tx_id)
from solana.core.fact_proposal_votes
where realms_id = 'B1CxhV1khhj7n5mi5hebbivesqH9mvXr5Hfh2nD2UCh6' and SUCCEEDED = 'TRUE' group by vote_choice),
Metaplex_Foundation as (
Run a query to Download Data