題解 | #?？偷恼n程訂單分析(六)#
?？偷恼n程訂單分析(六)
http://fangfengwang8.cn/practice/c5736983c322483e9f269dd23bdf2f6f
select t1.id id,is_group_buy,name client_name
from(select *
from(select *,count(user_id)over(partition by user_id) cn
from order_info
where date>'2025-10-15' and status='completed' and product_name in ('C++','Java','Python')) t
where cn>=2) t1 left join client c on t1.client_id=c.id
order by t1.id
查看14道真題和解析