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