题解 | #牛客的课程订单分析(六)#
牛客的课程订单分析(六)
http://www.nowcoder.com/practice/c5736983c322483e9f269dd23bdf2f6f
with t as (select * from order_info
where date>'2025-10-15' and status='completed' and product_name in('Python','Java','C++'))
select t1.id,is_group_buy,client.name client_name
from (select * from t where user_id in (select user_id from t group by user_id having count(*)>1)) t1
left join client
on t1.client_id=client.id
order by t1.id;