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