select count (user_address), membership

FROM

(

select distinct user_address, sum(balance),

CASE WHEN sum(balance)>=1000 THEN 'DAO_curator'

WHEN sum(balance)>=100 and sum(balance)<1000 THEN 'DAO_member'

else 'token_holder' end as membership

from ethereum.erc20_balances

where contract_address = '0x7e9d8f07a64e363e97a648904a89fb4cd5fb94cd'

and balance_date = CURRENT_DATE-1

group by 1

order by 1 desc

)

group by 2