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

SELECT order_info.id id,is_group_buy,name client_name
FROM order_info left join client on order_info.client_id = client.id
WHERE user_id in(
    SELECT user_id from order_info
    where datediff(date,"2025-10-15")>0 and product_name in("C++","Java","Python") and status = "completed"
    group by user_id
    having count(1)>=2
) and datediff(date,"2025-10-15")>0 and product_name in("C++","Java","Python") and status = "completed"
order by id