DATE(block_timestamp)as dayz,

description,

count (distinct tx_id) as votes,

count (distinct voter) as voters

from osmosis.core.fact_governance_votes g

join osmosis.core.dim_vote_options o on g.vote_option = o.vote_id

where tx_status = 'SUCCEEDED' and proposal_id ='362'

group by 1,2