题解 | #牛客的课程订单分析(五)#
牛客的课程订单分析(六)
http://www.nowcoder.com/practice/c5736983c322483e9f269dd23bdf2f6f
SELECT id,is_group_buy , name client_name FROM
(SELECT ,COUNT() OVER (PARTITION BY user_id) rn
FROM
(
SELECT o.* ,c.name
FROM order_info o
LEFT JOIN
client c
ON o.client_id=c.id) a
WHERE STATUS='completed'
AND DATE > '2025-10-15'
AND product_name IN ('c++','java','python')) b
WHERE rn>1
ORDER BY id ASC
查看14道真题和解析