select

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)

select

category,

proposal_id,

avg(vote_count) as average_votes,

avg(voter_count) as average_voters

from source

group by 1, 2