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

left join+count窗口函数

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