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

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;