题解 | 用户订单信息查询
用户订单信息查询
https://www.nowcoder.com/practice/dccec8456d774169925c0d50843ea076
select city, sum(total_amount) as total_order_amount from orders a join customers b on a.customer_id=b.customer_id group by city order by total_order_amount desc, city
凡岛公司福利 667人发布
查看11道真题和解析