VOTER,

count(distinct PROPOSAL_id) as no_proposals

from ethereum.aave.ez_votes

where BLOCK_TIMESTAMP >= CURRENT_DATE-180

group by 1

select

case

when no_proposals<3 then 'under 3 proposals'

when no_proposals>=3 and no_proposals<10 then '3-10 proposals'

when no_proposals>=10 and no_proposals<30 then '10-30 proposals'

when no_proposals>=30 then 'Over 30 proposals'

end as gp,

count(distinct voter) as no_voter

from tb1

group by 1 having gp is not null