题解 | #牛客的课程订单分析(一)#
牛客的课程订单分析(一)
http://www.nowcoder.com/practice/d3aa5df807f046bea5003dbc04965d67
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
