SELECT

COUNT(DISTINCT proposal_id) as total_props

FROM terra.core.fact_governance_votes

WHERE TX_SUCCEEDED = TRUE

SELECT

voter,

COUNT(DISTINCT proposal_id) / avg(total_props) as vote_percent,

COUNT(DISTINCT proposal_id) as votes

FROM terra.core.fact_governance_votes

LEFT OUTER JOIN tab0

WHERE TX_SUCCEEDED = TRUE

GROUP BY 1

ORDER BY 2 DESC