题解 | #牛客的课程订单分析(六)#
牛客的课程订单分析(六)
https://www.nowcoder.com/practice/c5736983c322483e9f269dd23bdf2f6f
select t.id,is_group_buy,name
from (
select *,count(*) over (partition by user_id) c
from order_info
where date>'2025-10-15'
and product_name in ('Java','Python','C++')
and status='completed'
) t
left join client c
on t.client_id=c.id
where c>=2
order by t.id asc