select
date(block_timestamp) as day,
description,
count(distinct tx_id) as votes,
count(distinct voter) as voters
from
osmosis.core.fact_governance_votes a join osmosis.core.dim_vote_options b on a.vote_option = b.vote_id
where
tx_status='SUCCEEDED' and proposal_id='362'
group by
day, description
order by
day asc