1.同一个用户下单2个及2个以上状态为购买成功的用户id

#select user_id 
#from order_info
#where status = "completed"
#group by user_id
#having count(user_id) >= 2

2.同一个用户下单2个以及2个以上状态为购买成功的C++课程或Java课程或Python课程的user_id

#select user_id
#from order_info
#where status = "completed"
#and product_name in ("C++", "Java", "Python")
#group by user_id
#having count(user_id) >= 2

3.在2025-10-15之后,且按照user_id升序排序

#select user_id
#from order_info
#where status = "completed"
#and product_name in ("C++", "Java", "Python")
#and date > '2025-10-15'
#group by user_id
#having count(user_id) >= 2
#order by user_id