ChiefVoters By Distribution
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
SELECT
n_voters,
count(DISTINCT realms_id) as dao_count,
count(CASE WHEN realms_id = 'HgcYAkXFT1ENpUCjBZWc1TjAAFacUwdGZRNhTHx9cuo' then realms_id END) as Hadeswap
FROM
(SELECT
realms_id,
count(DISTINCT voter) as n_voters
FROM
solana.core.fact_proposal_votes
WHERE
block_timestamp >= CURRENT_DATE - 30
GROUP BY
realms_id) t1
GROUP BY
n_voters
ORDER BY
n_voters DESC
Run a query to Download Data