题解 | #牛客的课程订单分析(四)#

牛客的课程订单分析(四)

http://www.nowcoder.com/practice/c93d2079282f4943a3771ca6fd081c23

select user_id, min(date) as first_buy_time, count(user_id) as cnt from order_info o where product_name in ('C++','Python','Java') and date > '2025-10-15' and status = 'completed' group by user_id having count(user_id) >= 2 order by user_id

全部评论

相关推荐

点赞 收藏 评论
分享
牛客网
牛客企业服务