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

利用窗口函数count()统计出符合条件的总数， 再进行条件删选r>=2 排序后得到答案

SELECT
a.id,
a.user_id,
a.product_name,
a.status,
a.client_id,
a.date
FROM
(
SELECT
*,
count(product_name) over(partition by user_id) r
from order_info
where status='completed'
and date>'2025-10-15'
and product_name in('C++','Java','Python')
)a
where a.r>=2
order by a.id