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