题解 | 牛客的课程订单分析(七)
牛客的课程订单分析(七)
https://www.nowcoder.com/practice/d6f4a37f966145da8900ba9edcc4c068
select ifnull(c.name,'GroupBuy') source, count(ifnull(c.id,1)) cnt
from (
select id, is_group_buy, client_id,
count(*) over(partition by user_id) as cnt
from order_info
where status = 'completed' and product_name in ('C++','Java','Python') and date > '2025-10-15'
) sub
left join client c on sub.client_id = c.id
where sub.cnt >= 2
group by c.id
order by source
，项目的话可以多写一下自己用到了哪些技术栈，这样面试官到时候有的问，也可以贴上自己的github地址，不过楼主这个学历已经很强了
