DISTINCT ACCOUNT_ID AS accounts,

SUM(BALANCE) AS balance

FROM stellar.core.fact_accounts

GROUP BY 1

ORDER BY 2 DESC

LIMIT 1000