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

sql script

select coalesce(c.name, 'GroupBuy') as source, count(*)
from order_info oi left join client c on oi.client_id=c.id
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(product_name) >= 2
                  order by user_id)
and date >= '2025-10-15'
and status='completed'
and product_name in ('C++', 'Java', 'Python')
group by source
order by source