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

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