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

SELECT * FROM order_info;

SELECT user_id,MIN(DATE),cnt FROM (SELECT ,COUNT() OVER (PARTITION BY user_id) cnt FROM order_info WHERE status='completed' AND product_name IN ('c++','python','java') AND DATE >'2025-10-15')a WHERE cnt>=2 GROUP BY user_id ORDER BY user_id ASC

；

SELECT user_id, MIN(DATE) first_buy_date, COUNT(*) cnt FROM order_info WHERE status='completed' AND product_name IN ('c++','python','java') AND DATE >'2025-10-15' GROUP BY user_id HAVING cnt>1 ORDER BY user_id ASC