题解 | 牛客的课程订单分析(四)
牛客的课程订单分析(四)
https://www.nowcoder.com/practice/c93d2079282f4943a3771ca6fd081c23
SELECT
user_id,
MIN(date) AS first_buy_date,--2025-10-15之后最小的日期
COUNT(*) AS cnt--总行数
FROM order_info
WHERE status = 'completed'
AND product_name IN ('C++','Java','Python')
AND date > '2025-10-15'
GROUP BY user_id--对id进行分组
HAVING COUNT(*) >= 2 总数大于等于2
ORDER BY user_id;
