83) 牛客的课程订单分析(七)

同一个代码块无限用，好耶！

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