题解 | #返回顾客名称和相关订单号以及每个订单的总价#
返回顾客名称和相关订单号以及每个订单的总价
https://www.nowcoder.com/practice/4dda66e385c443d8a11570a70807d250
select c.cust_name,oi.order_num, sum(oi.quantity*oi.item_price) as OrderTotal from Orders as o left join OrderItems as oi on o.order_num = oi.order_num left join Customers as c on o.cust_id = c.cust_id group by cust_name,order_num order by cust_name,order_num
Momenta公司福利 296人发布