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

# 3.22 9:11 ~ 9:14  3min

# 字段：answer_date，author_id，answer_cnt
# 时间：21年11月 每日

# tb1：
select answer_date,author_id,count(issue_id) as answer_cnt
from answer_tb
group by answer_date,author_id
having count(issue_id) >= 3 
order by answer_date,author_id