select date_trunc('hour',BLOCK_TIMESTAMP)as hour

,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 voting_type

,count(distinct TX_ID) as vote_count

,count(distinct VOTER) as voter_count

from osmosis.core.fact_governance_votes

where PROPOSAL_ID=394

and TX_SUCCEEDED='TRUE'

group by 1,2)

select voting_type

,avg(vote_count) as "AVG VOTE COUNT"

,avg(voter_count) as "AVG VOTER COUNT"

from tab1

group by 1