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

京公网安备 11010502036488号