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

用下左右链接即可

SELECT o.id,o.is_group_buy,c.name
FROM order_info o LEFT JOIN client c ON o.client_id=c.id
WHERE user_id in
(SELECT user_id
FROM order_info
WHERE product_name in('C++','JAVA','Python')
and status ='completed'
and date>'2025-10-15'
GROUP BY user_id
HAVING count(status)>=2
order by user_id)
AND product_name in('C++','JAVA','Python')
and status ='completed'
and date>'2025-10-15'