SELECT

voter,

proposal_id

FROM osmosis.core.fact_governance_votes

QUALIFY(ROW_NUMBER() over(PARTITION by voter

ORDER BY

proposal_id ASC)) = 1

)

SELECT

count(voter) as num_voters,

proposal_id

FROM new_voters

GROUP BY proposal_id

ORDER BY proposal_id asc