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