SELECT

account_id,

balance,

ROW_NUMBER() OVER (PARTITION BY account_id ORDER BY block_timestamp DESC) AS rn

FROM stellar.core.fact_accounts

SELECT

CASE

WHEN balance > 10000 THEN 'More than 10K XLM'

WHEN balance BETWEEN 1000 AND 10000 THEN '1K - 10K XLM'

WHEN balance BETWEEN 100 AND 999 THEN '100 - 999 XLM'

ELSE 'Less than 100 XLM'

END AS balance_range,

COUNT(*) AS user_count

FROM RankedBalances

WHERE rn = 1

GROUP BY balance_range

ORDER BY user_count DESC