题解 | #牛客的课程订单分析(六)#
牛客的课程订单分析(六)
http://www.nowcoder.com/practice/c5736983c322483e9f269dd23bdf2f6f
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
投递老虎国际等公司6个岗位
