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