题解 | 牛客的课程订单分析(六)
select o.id, o.is_group_buy, c.name client_name
from order_info o left join client c on o.client_id=c.id
where user_id in
(select a.user_id
from
(select user_id, count(user_id)
from order_info
where date>'2025-10-15' and status='completed' and product_name in ('C++','Java','Python')
group by user_id
having count(user_id)>=2
) a
order by a.user_id asc
)
and date>'2025-10-15' and status='completed' and product_name in ('C++','Java','Python')
order by id asc
查看10道真题和解析