SELECT
Customers.cust_name,
total_price
FROM
(
SELECT
AMT.order_num,
SUM(total_price) AS total_price
FROM
(
SELECT
order_num,
(item_price * quantity) AS total_price
FROM
OrderItems
) AS AMT
GROUP BY
AMT.order_num
) AS AMT1
INNER JOIN Orders ON Orders.order_num = AMT1.order_num
INNER JOIN Customers ON Customers.cust_id = Orders.cust_id
WHERE
AMT1.total_price >= 1000
Customers.cust_name,
total_price
FROM
(
SELECT
AMT.order_num,
SUM(total_price) AS total_price
FROM
(
SELECT
order_num,
(item_price * quantity) AS total_price
FROM
OrderItems
) AS AMT
GROUP BY
AMT.order_num
) AS AMT1
INNER JOIN Orders ON Orders.order_num = AMT1.order_num
INNER JOIN Customers ON Customers.cust_id = Orders.cust_id
WHERE
AMT1.total_price >= 1000
我已经通过这道题!
https://gw-c.nowcoder.com/api/sparta/jump/link?link=https%3A%2F%2Fwww.nowcoder.com%2FquestionTerminal%2Fb5766f970ae64ac7944f37f5b47107aa
全部评论
相关推荐
点赞 评论 收藏
分享
11-25 11:09
华南师范大学 电路设计工程师 点赞 评论 收藏
分享

