with lst_2022 as (
select
DISTINCT address
from osmosis.core.fact_daily_balances
where date>='2022-01-01'
)
select top 100
address as wallet
,balance/pow (10,decimal) as balances
from osmosis.core.fact_daily_balances
where date = CURRENT_DATE-1
and currency = 'uosmo'
and wallet in(select address from lst_2022)
order by balances DESC