count(DISTINCT osmosis.core.fact_daily_balances.address) as holders,---muber of holder by daily

sum(balance/ power(10, decimal)) as balance,----total suplly

sum(balance/ power(10, decimal)) / count(DISTINCT osmosis.core.fact_daily_balances.address) as balnce_avg

FROM osmosis.core.fact_daily_balances----i ud general tabel

LEFT outer JOIN osmosis.core.dim_labels--- i us general tabel

ON CURRENCY = osmosis.core.dim_labels.ADDRESS WHERE project_name LIKE 'OSMO' AND date > '2021-01-01' GROUP BY 1,2