题解 | 用户订单信息查询
用户订单信息查询
https://www.nowcoder.com/practice/dccec8456d774169925c0d50843ea076
select c.city,sum(total_amount) as total_order_amount from orders as o left join customers as c on o.customer_id = c.customer_id group by c.city order by total_order_amount desc,city
woyunxu我允许面试只考这样 的题
查看10道真题和解析
