题解 | #牛客的课程订单分析(六)#gary
牛客的课程订单分析(六)
http://www.nowcoder.com/practice/c5736983c322483e9f269dd23bdf2f6f
select x.id, is_group_buy, name client_name
from (select *, count(id) over(partition by user_id) cnt
from order_info
where datediff(date,"2025-10-15")>0
and status ="completed"
and product_name in ("C++","Java","Python")
) x
left join client y on x.client_id = y.id
where x.cnt > 1
order by x.id
