with

snapshot as

(select

count(distinct ID) as tx ,

VOTER

from external.snapshot.ez_snapshot

where SPACE_ID = 'toshibase.eth'

group by 2 order by 1 desc )

select

case

when tx = 1 then '1 Vote'

when tx = 2 then '2 Votes'

when tx = 3 then '3 Votes'

when tx = 4 then '4 Votes'

when tx = 5 then '5 Votes'

when tx = 6 then '6 Votes'

when tx = 7 then '7 Votes'

when tx = 8 then '8 Votes'

when tx = 9 then '9 Votes'

when tx = 10 then '10 Votes'

when tx between 10 and 20 then '10-20 Votes'

when tx between 20 and 30 then '20-30 Votes'

when tx between 30 and 40 then '30-40 Votes'

when tx between 40 and 50 then '40-50 Votes'

when tx > 50 then 'More than 50 Votes' end as "Number of Votes" ,

count(distinct VOTER) as "Number of Voters"

from snapshot

group by 1

order by min (tx)