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

with t1 as (
select id,client_id,is_group_buy
from order_info
where user_id in (
    select user_id 
    from order_info
    where date>'2025-10-15'
and status='completed'
and product_name in ('C++','Java','Python')
group by user_id
having count(user_id)>=2
)
    and date>'2025-10-15'
and status='completed'
and product_name in ('C++','Java','Python')
)
select case when is_group_buy='Yes' then 'GroupBuy'
else name
end as source,
count(a.id) as cnt
from t1 a 
left join client b 
on a.client_id=b.id
group by source
order by source