MLDZMNsnap6
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
›
⌄
with tb1 as (select
distinct VOTER,
count(distinct PROPOSAL_ID) as no_proposals,
count(*) as no_votes
from ethereum.core.ez_snapshot where NETWORK='Ethereum Mainnet'
group by 1
)
select
case
when no_proposals<3 then 'a. Under 3 proposals'
when no_proposals>=3 and no_proposals<10 then 'b. 3-10 proposals'
when no_proposals>=10 and no_proposals<50 then 'c. 10-50 proposals'
when no_proposals>=50 and no_proposals<150 then 'd. 50-150 proposals'
when no_proposals>=150 then 'e. Over 150 proposals'
end as gp,
count(distinct voter) "Number of voters"
from tb1
group by 1
Run a query to Download Data