题解 | #牛客的课程订单分析(三)#

错了吧

你子查询也要筛选一下，子查询查询出满足条件的user_id，但是用这个user_id查询的时候会有不满足条件的记录，需要筛选出去 SELECT o.* FROM order_info o WHERE o.user_id IN ( SELECT user_id FROM order_info WHERE status = 'completed' AND date > '2025-10-15' AND product_name IN ('Java', 'Python', 'C++') GROUP BY user_id HAVING COUNT(*) >= 2 ) and status = 'completed' AND date > '2025-10-15' AND product_name IN ('Java', 'Python', 'C++') ORDER BY o.id;

select * from order_info where date>'2025-10-15' and status='completed' and product_name in ('C++','Python','Java')and user_id in(select user_id from order_info where date>'2025-10-15' and status='completed' and product_name in ('C++','Python','Java') group by user_id having count(*)>=2) order by id; 条件少了，统计的时候把不满足的也统计进去了

你这个对不满足条件的row也进行count了，筛选条件错误了

答案错误

我照着你的代码抄了一遍是错的 我复制你的过来是对的- -