when (balance / pow(10,decimal)) BETWEEN 10 AND 100 then '10 - 100 $ATOM'

when (balance / pow(10,decimal)) BETWEEN 100 AND 1000 then '100 - 1k $ATOM'

when (balance / pow(10,decimal)) BETWEEN 1000 AND 10000 then '1K - 10K $ATOM'

else 'More Than 10K $ATOM' end as atom_balance,

count (distinct address) as voters

from osmosis.core.fact_daily_balances

where currency = 'ibc/27394FB092D2ECCD56123C74F36E4C1F926001CEADA9CA97EA622B25F41E5EB2' --atom

and address in (select voter

from (select voter,

count (distinct tx_id) as votes

from osmosis.core.fact_governance_votes

where tx_status = 'SUCCEEDED'

and proposal_id ='82'

group by 1

)

)

and date = (select MAX(date) from osmosis.core.fact_daily_balances)

group by 1

order by 2 desc