这个如何 WITH a AS ( SELECT * FROM order_info WHERE date > '2025-10-15' AND status LIKE 'c%' AND product_name IN ('C++', 'Java', 'Python') ) SELECT * FROM a WHERE ( SELECT COUNT(1) FROM (SELECT * FROM a) b WHERE user_id = a.user_id ) >= 2 ORDER BY id
点赞

相关推荐

牛客网
牛客网在线编程
牛客网题解
牛客企业服务