rakhisanjayaDISTRIBUTION OF NO OF VOTES BY CATEGORY
Updated 2023-01-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with voters as (
select
voter,
count(distinct proposal_id) as n_proposals
from terra.core.fact_governance_votes
group by voter
)
select
count(distinct voter) as no_of_voters,
CASE
WHEN n_proposals > 0 and n_proposals <= 1 THEN 'a.0-1'
WHEN n_proposals > 1 and n_proposals <= 10 THEN 'b.1-10'
WHEN n_proposals > 10 and n_proposals <= 50 THEN 'c.10-50'
WHEN n_proposals > 50 and n_proposals <= 1e2 THEN 'd.50-100'
WHEN n_proposals > 1e2 and n_proposals <= 2 * 1e2 THEN 'e.100-200'
WHEN n_proposals > 2 * 1e2 THEN 'f.> 200'
END as category
from voters
group by category
order by category
Run a query to Download Data