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