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

SELECT o.id,o.is_group_buy,c.name as client_name
FROM (select *,count(*) over(partition by user_id) as buy_num
      from order_info
      where product_name in('C++','Java','Python') and date>='2025-10-15' and status='completed' ) o left join client c on o.client_id=c.id
where o.buy_num>=2
order by o.id