DISTINCT address as user,

sum(balance/pow(10,6))

FROM osmosis.core.fact_daily_balances

WHERE CURRENCY = 'uosmo'

AND date ='2022-01-01'

group by 1

order by 2 desc

limit 100