题解 | 用户订单信息查询
用户订单信息查询
https://www.nowcoder.com/practice/dccec8456d774169925c0d50843ea076
# 城市总额
with
t1 as(
select
city,
sum(total_amount) as total_order_amount
from
orders left join customers using(customer_id)
group by
city
order by
total_order_amount desc,
city
)
select * from t1
