题解 | #牛客的课程订单分析(三)#
牛客的课程订单分析(三)
http://www.nowcoder.com/practice/4ae8cff2505f4d7cb68fb0ec7cf80c57
SELECT id,user_id,product_name,status,client_id,date FROM
(SELECT ,COUNT() OVER (PARTITION BY user_id) a
FROM order_info
WHERE product_name IN ('c++','Java','Python')
AND status='completed'
AND DATE >= '2025-10-15')b
WHERE a>=2 ORDER BY id ASC;
查看1道真题和解析
