Azinsolana 3-3 proposals
Updated 2022-12-01Copy Reference Fork
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 t1 as
(select
count(case when VOTE_CHOICE='YES' then 1 else null end) as yes,
count(case when VOTE_CHOICE='NO' then 1 else null end) as no,
count(case when VOTE_CHOICE is null then 1 else null end) as "null",
PROPOSAL
from
solana.core.fact_proposal_votes
group by PROPOSAL
)
(select
count(*) as number , 'accepted' as psotion
from
t1
where
yes>no)
union all
(select
count(*) as number , 'Rejected' as psotion
from
t1
where
yes<no)
union all
(select
count(*) as number , 'nulls' as psotion
from
t1
where
"null">yes and "null">no)
Run a query to Download Data