题解 | #牛客的课程订单分析(七)#
牛客的课程订单分析(七)
http://www.nowcoder.com/practice/d6f4a37f966145da8900ba9edcc4c068
思路:由于要取出所有订单,所以用窗口函数,case when+group by 得到新列
select
case when client_name is null then 'GroupBuy' else client_name end source
,count() cnt
from
(
select
o.id
,name client_name
,count()over(partition by user_id) cnt_a
from order_info o
left join client c on o.client_id = c.id
where date > '2025-10-15'
and status = 'completed'
and product_name in ('C++','Java','Python')
) a
where cnt_a>=2
group by 1
order by 1
sql刷题笔记 文章被收录于专栏
sql刷题笔记,有思路的讲解,不过比较简单,可以稍微启发你一下,留给你一些思考的空间。