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