select 
    * 
from 
    order_info 
where status='completed' 
    and (product_name='C++'or product_name='JAVA' OR product_name='Python') 
    and date>'2025-10-15'
order by id;