题解 | 牛客的课程订单分析(二)
牛客的课程订单分析(二)
https://www.nowcoder.com/practice/4ca4137cb490420cad06d2147ae67456
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(*)>1
order by user_id
需要注意聚合后的字段或者聚合函数不可用在where后
