SELECT
Customers.cust_name,
Orders.order_num,
(quantity*item_price) AS OrderTotal
FROM Orders
LEFT JOIN Customers ON Customers.cust_id = Orders.cust_id
LEFT JOIN OrderItems ON OrderItems.order_num = Orders.order_num
ORDER BY Customers.cust_name ASC
Customers.cust_name,
Orders.order_num,
(quantity*item_price) AS OrderTotal
FROM Orders
LEFT JOIN Customers ON Customers.cust_id = Orders.cust_id
LEFT JOIN OrderItems ON OrderItems.order_num = Orders.order_num
ORDER BY Customers.cust_name ASC
我已经通过这道题!
https://gw-c.nowcoder.com/api/sparta/jump/link?link=https%3A%2F%2Fwww.nowcoder.com%2FquestionTerminal%2F4dda66e385c443d8a11570a70807d250
全部评论
相关推荐
牛客78099800...:实习现在还不捞26届的啊,我投了很多,没有进流程的,以为是在搞秋招,但意外发现大三的不少都面实习了 点赞 评论 收藏
分享
12-03 15:50
天津理工大学 Unity3D客户端 点赞 评论 收藏
分享
美团成长空间 2663人发布