select

voter,

count(distinct proposal_id) as votes

from osmosis.core.fact_governance_votes

group by 1 )

select

case

when votes = 1 then 'One Vote'

when votes between 1.01 and 5 then 'Between 1 and 5 Votes'

when votes between 5 and 10 then 'Between 5 and 10 Votes'

when votes between 10 and 20 then 'Between 10 and 20 Votes'

when votes between 20 and 30 then 'Between 20 and 30 Votes'

when votes between 30 and 50 then 'Between 30 and 50 Votes'

else 'Greater than 30 Votes'

End as voter_votes_distribution,

count(*)

from tab1

group by 1