题解 | #牛客的课程订单分析(六)#
牛客的课程订单分析(六)
http://www.nowcoder.com/practice/c5736983c322483e9f269dd23bdf2f6f
用下左右链接即可
SELECT o.id,o.is_group_buy,c.name
FROM order_info o LEFT JOIN client c ON o.client_id=c.id
WHERE user_id in
(SELECT user_id
FROM order_info
WHERE product_name in('C++','JAVA','Python')
and status ='completed'
and date>'2025-10-15'
GROUP BY user_id
HAVING count(status)>=2
order by user_id)
AND product_name in('C++','JAVA','Python')
and status ='completed'
and date>'2025-10-15'
