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