WITH wallets_no as
(
SELECT count(address) as user_no
from osmosis.core.fact_daily_balances
where currency = 'uosmo'
and balance_type in ('liquid')
and date=CURRENT_DATE
),
total as
(
SELECT sum(balance/pow(10,decimal)) as total_osmo
from osmosis.core.fact_daily_balances
where currency = 'uosmo'
and balance_type in ('liquid')
and date=CURRENT_DATE
)
SELECT total_osmo/user_no as avg_osmo
from wallets_no, total