题解 | #输出提交次数大于2次的用户ID且倒序排列#
输出提交次数大于2次的用户ID且倒序排列
https://www.nowcoder.com/practice/e8601af30fc04e08aa87c64fffcff241
SELECT user_id
FROM (
SELECT
user_id,
COUNT(question_id) AS sub_num
FROM done_questions_record
GROUP BY user_id
HAVING sub_num >2
ORDER BY user_id DESC
) AS t1 -- Mysql要求必须起别名
投递众安保险等公司9个岗位 >