题解 | 每个客户的账户总金额
每个客户的账户总金额
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
每个客户的账户总金额
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
相关推荐
查看27道真题和解析