题解 | #牛客的课程订单分析(三)#
牛客的课程订单分析(三)
https://www.nowcoder.com/practice/4ae8cff2505f4d7cb68fb0ec7cf80c57
select
*
from
order_info
where
user_id in
(
select
A.user_id as user_id
from
(select
user_id
,count(status) as C
from order_info
where date>'2025-10-15' and product_name not in('JS') and status not in('no_completed')
group by user_id) as A
where A.C>=2
order by A.user_id
)
and date>'2025-10-15' and product_name not in('JS') and status not in('no_completed')
order by id
