date(block_timestamp) as date,

count(distinct tx_id) as total_votes,

count(distinct voter) as total_unique_voters,

case when vote_option = 1 then 'Yes'

when vote_option = 2 then 'Abstain'

when vote_option = 3 then 'No with veto'

when vote_option = 4 then 'No'

end as vote_type

from osmosis.core.fact_governance_votes

where TX_STATUS='SUCCEEDED'

and proposal_id = 82

group by vote_type , date

order by date desc