题解 | #牛客的课程订单分析(二)#
牛客的课程订单分析(二)
http://www.nowcoder.com/practice/4ca4137cb490420cad06d2147ae67456
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