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

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

http://www.nowcoder.com/practice/348afda488554ceb922efd2f3effc427

SELECT b.user_id,MIN(b.date) AS first_buy_date,(
SELECT MIN(a.date)
FROM order_info AS a
WHERE a.user_id=b.user_id AND a.date> MIN(b.date) AND a.status='completed' AND a.product_name IN ('C++','Java','Python')
) AS second_buy_date,COUNT() AS cnt
FROM order_info AS b
WHERE b.date>'2025-10-15' AND b.status='completed' AND b.product_name IN ('C++','Java','Python')
GROUP BY b.user_id
HAVING COUNT(
)>=2
ORDER BY b.user_id

先找到第一次购买成功日期,以及总个数,再找到排除首日购买后的最小日期;

全部评论

相关推荐

点赞 评论 收藏
分享
评论
点赞
收藏
分享

创作者周榜

更多
牛客网
牛客企业服务