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