题解 | #牛客的课程订单分析(一)#
牛客的课程订单分析(一)
https://www.nowcoder.com/practice/d3aa5df807f046bea5003dbc04965d67
select * from order_info where date>'2025-10-15' and status ='completed' and product_name in('C++','Python','Java') order by id asc
注意:1.日期筛选有两种方法datediff(date,"2025-10-15")>0 或date>'2025-10-15'