select to_date(block_timestamp) as date,

description as options,

count (distinct tx_id) as total_votes,

count (distinct voter) as total_voters

from osmosis.core.fact_governance_votes votes join osmosis.core.dim_vote_options options on votes.vote_option = options.vote_id

where tx_status = 'SUCCEEDED'

and proposal_id in ('362')

and date >= '2022-01-01'

group by date, options

select * from votes