题解 | #牛客每个人最近的登录日期(二)#

SELECT *
FROM order_info
WHERE user_id IN (SELECT user_id
FROM order_info
WHERE date>'2025-10-15'
AND status='completed'
AND product_name IN ('C++','Java','Python')
GROUP BY user_id
HAVING COUNT(user_id)>=2)
AND date>'2025-10-15'
AND status='completed'
AND product_name IN ('C++','Java','Python')
ORDER BY id