题解 | #牛客的课程订单分析(二)#
牛客的课程订单分析(二)
http://www.nowcoder.com/practice/4ca4137cb490420cad06d2147ae67456
按照题目要求限制字段，然后按照user_id分组，限制每组数量大于等于2，最后根据user_id排序
select user_id from order_info
where (product_name = "Java" or product_name = "Python" or product_name = "C++") and
date > "2025-10-15" and status = "completed"
group by user_id
having count(id) >= 2
order by user_id
