WITH
TOP100 AS (select
ADDRESS,
SUM (BALANCE/pow(10,DECIMAL)) AS BALANCE
FROM osmosis.core.fact_daily_balances
WHERE CURRENCY = 'uosmo'
AND DATE = '2022-10-26'
GROUP BY 1 ORDER BY BALANCE DESC LIMIT 100)
select
'Start Of The Year' AS TYPE,
SUM ( BALANCE/pow(10,DECIMAL)) AS BALANCE
FROM osmosis.core.fact_daily_balances
WHERE CURRENCY = 'uosmo'
AND DATE = '2022-01-01'
AND ADDRESS IN (SELECT ADDRESS FROM TOP100)
GROUP BY 1
UNION
select
'Current Date' AS TYPE,
SUM ( BALANCE/pow(10,DECIMAL)) AS BALANCE
FROM osmosis.core.fact_daily_balances
WHERE CURRENCY = 'uosmo'
AND DATE = '2022-10-26'
AND ADDRESS IN (SELECT ADDRESS FROM TOP100)