题解 | 每个客户的账户总金额
每个客户的账户总金额
https://www.nowcoder.com/practice/19f0bc2b8cad44b6986ad9a51ed43def
select customer_id ,sum(balance) as sum_balance from account group by customer_id order by sum_balance desc
每个客户的账户总金额
https://www.nowcoder.com/practice/19f0bc2b8cad44b6986ad9a51ed43def
select customer_id ,sum(balance) as sum_balance from account group by customer_id order by sum_balance desc
相关推荐