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