block_timestamp::date as day,

count(distinct tx_id) as vote_count,

count(distinct voter) as voter_count,

case

when proposal_id = '362' then '362'

when proposal_id != '362' then 'Others'

end as category,

proposal_id

from osmosis.core.fact_governance_votes

where proposal_id > 350

and TX_STATUS = 'SUCCEEDED'

group by category, proposal_id, day