题解 | #牛客的课程订单分析(一)#
牛客的课程订单分析(一)
http://www.nowcoder.com/practice/d3aa5df807f046bea5003dbc04965d67
很直接的选全部字段,然后按题目要求限制条件并排序
select * from order_info
where date > "2025-10-15" and status = "completed" and
(product_name = "C++" or product_name = "Java" or product_name = "Python")
order by id