思路:按照题目所提出的要求,一个一个的对条件做查询

完整代码:

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