proposal_id, lower(description) as description,

count(distinct(voter)) as voters,

sum(vote_weight) as voting_power,

count(distinct(tx_id)) as tx_number

from osmosis.core.fact_governance_votes a

left join osmosis.core.dim_vote_options b

where 1 = 1

and b.vote_id = a.vote_option

and proposal_id in (337, 114, 196)

and a.tx_status = 'SUCCEEDED'

and a.block_timestamp::date >= current_date - {{ days }}

group by proposal_id, description

order by tx_number desc