题解 | #牛客的课程订单分析(六)#
牛客的课程订单分析(六)
https://www.nowcoder.com/practice/c5736983c322483e9f269dd23bdf2f6f
SELECT t1.id id,is_group_buy,name client_name
FROM (
SELECT *,count(1) over(partition by user_id) number from order_info
where datediff(date,"2025-10-15")>0 and product_name in("C++","Java","Python") and status = "completed"
)t1 left join client t2
on t1.client_id = t2.id
where number > 1
order by t1.id
字节跳动成长空间 989人发布