题解 | #牛客的课程订单分析(四)#
牛客的课程订单分析(四)
https://www.nowcoder.com/practice/c93d2079282f4943a3771ca6fd081c23
SELECT user_id
,MIN(date) as first_buy_date
,COUNT(product_name) as cnt
FROM order_info
WHERE date >"2025-10-15"
AND product_name IN ("Python","C++","Java")
AND status="completed"
GROUP BY user_id
HAVING COUNT(product_name)>1