题解 | #牛客的课程订单分析(一)#

1.分析
where条件中日期的对比，要加引号。

2.代码

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 order_info.id