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