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
全部评论
相关推荐
点赞 评论 收藏
分享
点赞 评论 收藏
分享
沉淀小子:干啥都不丢人啊,生存是必须要的,销售很考验一个人综合素质能力的,好的销售人脉和资源可不比写字楼的白领差啊 点赞 评论 收藏
分享
04-30 17:09
门头沟学院 游戏策划 点赞 评论 收藏
分享
