题解 | #牛客的课程订单分析(四)#
牛客的课程订单分析(四)
https://www.nowcoder.com/practice/c93d2079282f4943a3771ca6fd081c23
select user_id, min(date) as first_buy_date, count(date) as cnt from order_info where date > '2025-10-15' and (product_name = 'C++' or product_name = 'Python' or product_name = 'Java') and status = 'completed' group by user_id having count(date) >= 2 order by user_id
查看1道真题和解析
