题解 | #牛客的课程订单分析(一)#
牛客的课程订单分析(一)
https://www.nowcoder.com/practice/d3aa5df807f046bea5003dbc04965d67
SELECT
id
,user_id
,product_name
,status
,client_id
,date
-- ,REPLACE(date,'-','') date
FROM order_info
WHERE product_name IN ('C++','Java','Python')
AND status = 'completed'
AND REPLACE(date,'-','') >= 20251015
;
