SELECT
proposal_id,
-- voter,
count(*) as no_of_votes,
count(distinct voter) as no_of_voters,
count(*) / count(distinct voter) as avg_vote_per_voter
from cosmos.core.fact_governance_votes
-- where tx_succeeded
-- and proposal_id = 38
group by 1
order by 4 desc