with a as(
select
answer_date,
author_id,
count(*) as answer_cnt
from
answer_tb
group by
answer_date,
author_id
having
answer_cnt>=3
order by
answer_date asc,
author_id asc
)
select * from a

京公网安备 11010502036488号