題解 | #?？兔總€人最近的登錄日期(二)#
?？偷恼n程訂單分析(三)
http://fangfengwang8.cn/practice/4ae8cff2505f4d7cb68fb0ec7cf80c57
SELECT *
FROM order_info
WHERE user_id IN (SELECT user_id
FROM order_info
WHERE date>'2025-10-15'
AND status='completed'
AND product_name IN ('C++','Java','Python')
GROUP BY user_id
HAVING COUNT(user_id)>=2)
AND date>'2025-10-15'
AND status='completed'
AND product_name IN ('C++','Java','Python')
ORDER BY id
查看8道真題和解析
