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

select
info.id
,info.is_group_buy
,cl.name as client_name
from 
order_info info left join
client  cl
on
info.client_id=cl.id
where
user_id in
(
select
A.user_id as user_id
from 
(select
user_id
,count(status) as C
from order_info
where date>'2025-10-15' and product_name not in('JS') and status not in('no_completed')
group by user_id) as A
where A.C>=2
order by A.user_id
)
and info.date>'2025-10-15' and info.product_name not in('JS') and info.status not in('no_completed')
order by info.id