DISTINCT VOTER

from osmosis.core.fact_governance_votes

where PROPOSAL_ID = 362

and TX_STATUS ='SUCCEEDED'

)

select

BALANCE_TYPE , sum(BALANCE)/1e6 as total

from osmosis.core.fact_daily_balances a JOIN voter b on a.address= b.voter

where

CURRENCY = 'uosmo'

and DATE = CURRENT_DATE -1

group by BALANCE_TYPE