题解 | #返回顾客名称和相关订单号以及每个订单的总价#
返回顾客名称和相关订单号以及每个订单的总价
https://www.nowcoder.com/practice/4dda66e385c443d8a11570a70807d250
select a.cust_name,b.order_num,c.OrderTotal from
Customers as a,Orders as b,
(select order_num,quantity*item_price as OrderTotal from OrderItems) as c
where a.cust_id = b.cust_id
and b.order_num = c.order_num
order by cust_name asc,order_num asc
Customers as a,Orders as b,
(select order_num,quantity*item_price as OrderTotal from OrderItems) as c
where a.cust_id = b.cust_id
and b.order_num = c.order_num
order by cust_name asc,order_num asc
查看8道真题和解析
拼多多集团-PDD公司福利 470人发布
投递58到家等公司10个岗位 >