题解 | #牛客的课程订单分析(四)#

SELECT user_id

    ,MIN(date) as first_buy_date

    ,COUNT(product_name) as cnt

FROM order_info

WHERE date >"2025-10-15"

AND product_name IN ("Python","C++","Java")

AND status="completed"

GROUP BY user_id

HAVING COUNT(product_name)>1