题解 | 牛客的课程订单分析(一)
牛客的课程订单分析(一)
https://www.nowcoder.com/practice/d3aa5df807f046bea5003dbc04965d67
select id,user_id,product_name,status,client_id,date
from order_info
where year(date) >= 2025
and month(date) >= 10
and day(date)>15
and product_name in ('C++','Java','Python')
and status = 'completed'
ORDER BY id
投递小米集团等公司7个岗位