adambalaDetails Table
Updated 2023-02-06
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 a as
(select
count(distinct ID) as vote ,
count(distinct VOTER) as VOTERs ,
sum(VOTING_POWER) as voting_powers ,
PROPOSAL_ID as PROPOSAL
from ethereum.core.ez_snapshot --where PROPOSAL_ID ='0xcfc63eee1d5dde8e890deec9aca9d1e3965c99f864a4bc6da1dbf273ac5ae3c4'
where SPACE_ID = 'doodles.eth'
group by 4
)
select
distinct PROPOSAL_ID as PROPOSAL_ID ,
case when vote between 1 and 10 then '🔥'
when vote between 10 and 50 then '🔥🔥'
when vote between 50 and 100 then '🔥🔥🔥'
when vote between 100 and 1000 then '🔥🔥🔥🔥'
else '🔥🔥🔥🔥🔥' end as popularity,
vote,
VOTERs,
voting_powers,
voting_powers/10000 || '%'as voting_powers_ratio ,
PROPOSAL_TITLE ,
CHOICES ,
QUORUM ,
VOTING_PERIOD ,
PROPOSAL_START_TIME ,
PROPOSAL_END_TIME ,
PROPOSAL_TEXT ,
case when voting_powers between 1 and 10 then '♨️'
when voting_powers between 10 and 50 then '♨️♨️'
when voting_powers between 50 and 100 then '♨️♨️♨️'
when voting_powers between 100 and 1000 then '♨️♨️♨️♨️'
Run a query to Download Data