题解 | #牛客的课程订单分析(七)#
牛客的课程订单分析(七)
http://www.nowcoder.com/practice/d6f4a37f966145da8900ba9edcc4c068
select distinct case when c.name is null then 'GroupBuy' else c.name end source,t.number
from client c right join
(
select client_id ,count(*) over(partition by user_id) pnumber,
count(*) over(partition by client_id) number
from order_info
where datediff(date,"2025-10-15")>0
and status ="completed"
and product_name in ("C++","Java","Python")
) t
on c.id = t.client_id
where t.pnumber>1
order by source
from client c right join
(
select client_id ,count(*) over(partition by user_id) pnumber,
count(*) over(partition by client_id) number
from order_info
where datediff(date,"2025-10-15")>0
and status ="completed"
and product_name in ("C++","Java","Python")
) t
on c.id = t.client_id
where t.pnumber>1
order by source
诺瓦星云一面218人在聊