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