select * from order_info
where datediff(date,'2025-10-15')>0
and product_name in ('C++','Java','Python')
and status='completed'
order by id
  • 注意筛选条件
  • 课程名
  • 日期
  • 订单状态