题解 | 牛客的课程订单分析(一)
牛客的课程订单分析(一)
https://www.nowcoder.com/practice/d3aa5df807f046bea5003dbc04965d67
# 成功购买 c++或者java或者python id排序
select
*
from
order_info
where
status='completed'
and
product_name in('C++','Java','Python')
and
timestampdiff(day,'2025-10-15',date)>=0
order by
id