新的练习!

筛选条件

  • C++课程或者Java课程或者Python
  • 在2025-10-15以后
  • 状态为购买成功
select id, user_id, product_name, status, client_id, date
from order_info
where date > '2025-10-15'
and product_name in ('C++','Java','Python')
and status = 'completed'
order by id asc;