proposal_id,

description,

case

when proposal_id = '362' then 'Proposal no.362'

else 'Other Proposals'

end as gp,

count (distinct tx_id) as votes,

count (distinct voter) as voters

from osmosis.core.fact_governance_votes a

left join osmosis.core.dim_vote_options b on a.vote_option = b.vote_id

where proposal_id::numeric >= '340'

and tx_status = 'SUCCEEDED'

group by 1,2,3