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

with order_info_2 as (
    select * from order_info where user_id in (
    select a.user_id from (
    select * from order_info
    where date > '2025-10-15' and status = 'completed' and product_name in ('C++', 'Python','Java')
) a group by a.user_id
having count(*) >=2
) and date > '2025-10-15' and status = 'completed' and product_name in ('C++', 'Python','Java')
),
order_info_3 as (
    select o.id,COALESCE(c.name, 'GroupBuy') as source
    from order_info_2 o left join client c on o.client_id=c.id
order by o.id
)
select source ,count(id) as cnt from order_info_3
group by source
order by source