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