题解 | 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;
# 这里需要注意的是：回答问题个数不考虑问题是否重复的问题！
美的集团公司福利 720人发布
查看11道真题和解析