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

select b.id , is_group_buy, name client_name
from
    (
    select id , is_group_buy, client_id,  count(id)over(partition by user_id) cnt
    from order_info
    where date>= '2025-10-15' 
    and status = 'completed'
    and product_name in ('C++','Java','Python')
    ) b  left join client on b.client_id = client.id
where cnt>=2 
order by id
#join之后需要排序