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