2022-10-18 14:02 西安欧亚学院 大数据开发工程师 发布于浙江
关注
笨办法
SELECT * FROM (
SELECT
AMT.order_num,
SUM(AMT.total_price) AS total_price
FROM (
select
order_num,
(item_price * quantity) as total_price
from orderitems
) AMT
GROUP BY AMT.order_num ORDER BY AMT.order_num
) AS ANYE WHERE ANYE.total_price >= 1000
SELECT * FROM (
SELECT
AMT.order_num,
SUM(AMT.total_price) AS total_price
FROM (
select
order_num,
(item_price * quantity) as total_price
from orderitems
) AMT
GROUP BY AMT.order_num ORDER BY AMT.order_num
) AS ANYE WHERE ANYE.total_price >= 1000
我已经通过这道题！
https://gw-c.nowcoder.com/api/sparta/jump/link?link=https%3A%2F%2Fwww.nowcoder.com%2FquestionTerminal%2Fd8a624021183454586da94d280cc8046
全部评论
相关推荐
汤臣倍健公司氛围 393人发布
点赞 评论 收藏
分享
