题解 | #牛客的课程订单分析(六)#
牛客的课程订单分析(六)
http://www.nowcoder.com/practice/c5736983c322483e9f269dd23bdf2f6f
select id,is_group_buy,if(is_group_buy='yes',null,client_name) client_name from
(select o.id,o.client_id,is_group_buy,name client_name,count(user_id)over(partition by user_id) cnt
from order_info o
left join client c
on o.client_id=c.id
where date >'2025-10-15'
and product_name in("c++","python","java")
and status ='completed' )a
where cnt >=2
order by id
简单说，没啥想法，顺着题意一个一个写条件就好了，但我想吐槽的是，我没列没写别名居然也通过了。
查看7道真题和解析
