题解 | #输出提交且通过次数大于2 的用户ID且升序排列#

SELECT
    user_id
FROM
    (
        SELECT
            user_id,
            SUM(result_info) AS submit_pass_num
        FROM
            done_questions_record
        WHERE
            result_info = 1 -- 只统计提交通过的情况
        GROUP BY
            user_id
        HAVING
            submit_pass_num > 2 -- 找出通过次数大于2的记录
    ) AS subquery
ORDER BY
    user_id ASC
;