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

select
t1.id
,case when client_id = 0 then 'Yes'
      else 'No' end is_group_buy
,name 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
)
order by 1