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

select *, count(*) over(partition by user_id) as cnt from order_info
where date > '2025-10-15'
and product_name in ('C++','Java','Python')
and status = 'completed'

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