select customer_id, sum(balance) as sum_balance
from account
group by customer_id
order by sum_balance desc