with voter_status as (
select voter,
count (distinct tx_id) as votes
from osmosis.core.fact_governance_votes
where tx_status = 'SUCCEEDED' and proposal_id ='362'
group by 1)
select
avg (balance / pow(10,decimal)) as balance
from osmosis.core.fact_daily_balances
where currency = 'uosmo' and address in (select voter from voter_status)
and date = (select MAX(date) from osmosis.core.fact_daily_balances)