题解 | #输出提交且通过次数大于2 的用户ID且升序排列#
输出提交且通过次数大于2 的用户ID且升序排列
https://www.nowcoder.com/practice/180ddfdf30ce4303bac02f4ca0af43d5
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
;
美团成长空间 2667人发布
查看8道真题和解析