select

proposal_id,

count(distinct voter) as Votes

from osmosis.core.fact_governance_votes

group by 1 )

select

case

when Votes between 0 and 2500 then 'Between 0 and 2.5K votes'

when Votes between 2500 and 5000 then 'Between 2.5K and 5K votes'

when Votes between 5000 and 10000 then 'Between 5K and 10K votes'

when Votes between 10000 and 15000 then 'Between 10K and 15K votes'

when Votes between 15000 and 20000 then 'Between 15K and 20K votes'

when Votes between 20000 and 30000 then 'Between 20K and 30K votes'

else 'MORE than 30k Votes'

end as Proposal_votes_Distribution,

count(*)

from table1

group by 1