count(distinct ID) as tx ,

VOTER

from ethereum.core.ez_snapshot where SPACE_ID = 'doodles.eth'

group by 2 order by 1 desc )

select

case

when tx = 1 then '1 VOTE'

when tx = 2 then '2 VOTE'

when tx = 3 then '3 VOTE'

when tx = 4 then '4 VOTE'

when tx = 5 then '5 VOTE'

when tx = 6 then '6 VOTE'

when tx = 7 then '7 VOTE'

when tx = 8 then '8 VOTE'

when tx = 9 then '9 VOTE'

when tx = 10 then '10 VOTE'

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

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

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

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

when tx > 50 then 'more than 50 VOTE' end as number_tx

, count(distinct VOTER)

from a group by 1