题解 | #牛客的课程订单分析(二)#
牛客的课程订单分析(二)
https://www.nowcoder.com/practice/4ca4137cb490420cad06d2147ae67456
SELECT
user_id user_id
FROM
order_info
WHERE date>"2025-10-15"
AND product_name in ("C++","Java","Python")
AND status="completed"
GROUP BY user_id
HAVING count(id)>1
ORDER BY user_id
基础题,注意语句执行顺序即可

查看1道真题和解析