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

SELECT * 
FROM order_info oi
WHERE oi.user_id IN
(select user_id
from order_info
where datediff(date,"2025-10-15")>0
  and status ="completed"
  and product_name in("C++","Java","Python")
group by user_id
having count(id)>=2)
  and datediff(oi.date,"2025-10-15")>0
  and oi.status ="completed"
  and oi.product_name in("C++","Java","Python")
ORDER BY oi.id