题解 | #输出提交次数大于2次的用户ID且倒序排列#
输出提交次数大于2次的用户ID且倒序排列
https://www.nowcoder.com/practice/e8601af30fc04e08aa87c64fffcff241
SELECT
user_id
FROM
(
SELECT
user_id,
COUNT(user_id) AS submit_counts
FROM
done_questions_record
GROUP BY
user_id
HAVING
submit_counts > 2
) AS subquery
ORDER BY
user_id DESC
;
嘉士伯公司氛围 714人发布