题解 | #牛客的课程订单分析(六)#
牛客的课程订单分析(六)
http://www.nowcoder.com/practice/c5736983c322483e9f269dd23bdf2f6f
select t.id,is_group_buy,name as client_name
from
(
select id,is_group_buy,client_id,count(*)over(partition by user_id) as cnt
from order_info
where date > '2025-10-15'
and product_name in ('C++', 'Python', 'Java')
and status = 'completed'
)t
left join client c
on t.client_id = c.id
where cnt >=2
order by t.id
广电运通公司福利 172人发布
投递腾讯等公司6个岗位
滴滴二面352人在聊
查看11道真题和解析