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

可以直接写where date > '2025-10-15'，不用加date转化函数