题解 | 返回顾客名称和相关订单号以及每个订单的总价
返回顾客名称和相关订单号以及每个订单的总价
https://www.nowcoder.com/practice/4dda66e385c443d8a11570a70807d250
select
c.cust_name,
o.order_num,
(os.quantity * os.item_price) as OrderTotal
from Customers c
join Orders o on c.cust_id = o.cust_id
join OrderItems os on o.order_num = os.order_num
order by c.cust_name,OrderTotal asc
查看14道真题和解析