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

-- 先找出满足超过1单条件的user_id; 再查询订单信息表去除user_id中不符合条件的订单。

select * from order_info 
where user_id in (
  select user_id  from order_info 
	   where datediff(date, '2025-10-15') > 0 
	   and status = 'completed' 
	   and product_name in ('Java','Python','C++')
	   group by user_id
	   having count(product_name) > 1
) 
and date > '2025-10-15' 
and status = 'completed' 
and product_name in ('Java','Python','C++')
order by id;