select * from order_info 
 where date>'2025-10-15' 
    and status ='completed' 
    and product_name in('C++','Python','Java') 
 order by id asc

注意：1.日期筛选有两种方法datediff(date,"2025-10-15")>0 或date>'2025-10-15'