题解 | SQL 192. 某乎问答单日回答问题数大于等于3个的所有用户

WITH t1 AS (
    SELECT answer_date,
           author_id,
           count(issue_id) AS answer_cnt
    FROM answer_tb
    WHERE SUBSTR(answer_date,6,2) = '11'
    GROUP BY answer_date, author_id
    HAVING answer_cnt >= 3
    ORDER BY answer_date ASC, author_id ASC
)
SELECT * FROM t1;

# 这里需要注意的是：回答问题个数不考虑问题是否重复的问题！