题解 | 用户订单信息查询
用户订单信息查询
https://www.nowcoder.com/practice/dccec8456d774169925c0d50843ea076
select city,sum(total_amount) as total_order_amount from orders a join customers b using(customer_id) group by city order by total_order_amount desc,city
用户订单信息查询
https://www.nowcoder.com/practice/dccec8456d774169925c0d50843ea076
select city,sum(total_amount) as total_order_amount from orders a join customers b using(customer_id) group by city order by total_order_amount desc,city
相关推荐
斯卡蒂味的鱼汤:知道你不会来数马,就不捞你😂最近数马疯狂扩招,招聘要求挺低的,你能力肯定够,应该就是因为太强了,知道你不会来才不捞你