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

select 
    t1.answer_date, t1.author_id, t1.answer_cnt
from(
    select 
        answer_date, author_id, count(issue_id) as answer_cnt
    from 
        answer_tb
    group by 
        author_id, answer_date
)t1
where 
    answer_cnt >= 3 and date_format(answer_date, '%Y-%m') = '2021-11'
order by 
    answer_date, author_id