目录 一、题目二、代码三、运行结果 一、题目 二、代码 select Orders.cust_id, sum(OrderItems.item_price * OrderItems.quantity ) as price from OrderItems join Orders on OrderItems.order_num = Orders.order_num group by (Orders.cust_id) order by price desc 三、运行结果