SELECT to_char(proposal_id) as proposal,

DENSE_rank()over(ORDER BY proposal_id DESC) as prop_no, *

FROM terra.core.fact_governance_votes

WHERE tx_succeeded = 'TRUE'

SELECT proposal,

prop_no,

vote_option_text,

COUNT (DISTINCT tx_id) as n_votes,

COUNT(DISTINCT voter) as n_voters

FROM ranked_proposals

WHERE prop_no <= 5

GROUP BY proposal,prop_no,vote_option_text