题解 | #牛客的课程订单分析(六)#
牛客的课程订单分析(六)
https://www.nowcoder.com/practice/c5736983c322483e9f269dd23bdf2f6f
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