题解 | #牛客的课程订单分析(三)#
牛客的课程订单分析(三)
https://www.nowcoder.com/practice/4ae8cff2505f4d7cb68fb0ec7cf80c57
# 内表找出user_id，外表找出该user_id符合的记录。
with t as
(
select user_id
from order_info
where datediff(date,"2025-10-15") > 0
and status = "completed"
and product_name in ("C++","Java","Python")
group by user_id
having count(id)>=2
)
select *
from order_info
where user_id in (select * from t)
and datediff(date,"2025-10-15") > 0
and status = "completed"
and product_name in ("C++","Java","Python")
order by id
投递亚马逊等公司10个岗位 >
