题解 | #牛客的课程订单分析(六)#
实习广场投递简历分析(三)
http://www.nowcoder.com/practice/83f84aa5c32b4cf5a75558d02dd7743c
SELECT o.id,o.is_group_buy,c.name as client_name
FROM (select *,count(*) over(partition by user_id) as buy_num
from order_info
where product_name in('C++','Java','Python') and date>='2025-10-15' and status='completed' ) o left join client c on o.client_id=c.id
where o.buy_num>=2
order by o.id
投递锐捷网络股份有限公司等公司10个岗位 >
携程公司氛围 85人发布