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