牛客的课程订单分析（六）

select d.id, d.is_group_buy, c.name as client_name
from order_info d left join client c on d.client_id = c.id, (select o.user_id
from order_info o
where o.date >= '2025-10-15' and o.product_name in ('Python','C++','Java') and o.status = 'completed'
group by o.user_id
having count(o.id) >=2
order by o.id) t
where t.user_id = d.user_id and d.date >= '2025-10-15'
and d.product_name in ('Python','C++','Java') and d.status = 'completed'