题解 | #返回顾客名称和相关订单号以及每个订单的总价#
返回顾客名称和相关订单号以及每个订单的总价
https://www.nowcoder.com/practice/4dda66e385c443d8a11570a70807d250
with t as (
select
c.cust_name,
d.order_num,
e.quantity,
e.item_price
from
Customers c left join Orders d on c.cust_id = d.cust_id
right join OrderItems e on d.order_num = e.order_num
)select
cust_name,
order_num,
sum(quantity * item_price) OrderTotal
from t
group by cust_name,order_num
order by cust_name
#题解#
select
c.cust_name,
d.order_num,
e.quantity,
e.item_price
from
Customers c left join Orders d on c.cust_id = d.cust_id
right join OrderItems e on d.order_num = e.order_num
)select
cust_name,
order_num,
sum(quantity * item_price) OrderTotal
from t
group by cust_name,order_num
order by cust_name
#题解#
投递京东等公司9个岗位