题解 | 牛客的课程订单分析(六)
牛客的课程订单分析(六)
https://www.nowcoder.com/practice/c5736983c322483e9f269dd23bdf2f6f
select t1.id,t1.is_group_buy,t1.client_name from
(select oi.id,is_group_buy,name client_name,count(*)over(partition by user_id) cnt
from order_info oi left join client
on oi.client_id = client.id
where product_name in ("C++","Java","Python")
and status = "completed") as t1
where cnt >= 2
order by t1.id
嘟嘟嘟，跟前面的差不多
你cet6就cet6，cet4就cet4，你写个cet证书等是什么意思。专业技能快赶上项目行数，你做的这2个项目哪里能提现你有这么多技能呢
