题解 | #牛客的课程订单分析(二)#
牛客的课程订单分析(二)
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) >= 23.在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