rahoCopy of Voters
Updated 2023-01-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with all_ss as (
select
*
from ethereum.core.ez_snapshot
where space_id = 'opcollective.eth'
),
calc as (
select
count(distinct proposal_author) as prop_authors,
count(distinct voter) as unique_voters,
count(distinct proposal_title) as total_proposals
from all_ss
)
select
*
from calc