题解 | 每个客户的账户总金额
每个客户的账户总金额
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,customer_id asc
每个客户的账户总金额
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,customer_id asc
相关推荐