题解 | #牛客的课程订单分析(三)#

select o.id, o.user_id, o.product_name, o.status, o.client_id, o.date
from order_info o
join
(select id, user_id, product_name, status, client_id, date
from order_info
where date > '2025-10-15'
and status = 'completed'
and product_name in ('C++','Java','Python')
group by user_id
having count(id) > 1)a
on a.user_id = o.user_id
where o.date > '2025-10-15'
and o.status = 'completed'
and o.product_name in ('C++','Java','Python')
order by o.id asc;