with act1 as (
select
VOTER
from osmosis.core.fact_governance_votes
where PROPOSAL_ID=98
and TX_SUCCEEDED='TRUE'),
act2 as (
with tab1 as (
select SENDER
,sum(AMOUNT/1e6) as dep_amount
from cosmos.core.fact_transfers
where CURRENCY='uatom'
group by 1),
tab2 as (
select RECEIVER
,sum(AMOUNT/1e6) as with_amount
from cosmos.core.fact_transfers
where CURRENCY='uatom'
group by 1)
select RECEIVER
,with_amount-dep_amount as atom_balance
from tab1
left join tab2
on tab1.SENDER=tab2.RECEIVER)
select 'VOTER'as type
,avg(atom_balance) as avg
,max(atom_balance) as max
,min(atom_balance) as min
from act2
where RECEIVER in (select VOTER from act1)