如何在StackOverflow表中按日期统计指定时间范围内的数值总和？

• 实现指定日期范围的字段汇总，核心是用GROUP BY按日期分组，搭配SUM()聚合函数计算总和，结合WHERE过滤日期范围。

基础SQL示例 #

SELECT 
    Date,
    SUM(num_of_questions) AS total_questions,
    SUM(num_of_answers) AS total_answers
FROM StackOverflow
WHERE Date BETWEEN '2022-09-01' AND '2022-09-02'
GROUP BY Date
ORDER BY Date;

关键说明 #

• SUM(num_of_questions)、SUM(num_of_answers)：分别对每日的问题数、回答数求和，生成汇总后的统计值
• GROUP BY Date：强制按日期维度分组，确保每个日期只返回一条汇总记录
• WHERE子句：精准筛选出目标日期范围内的数据，避免无关数据干扰结果

处理含时间的日期字段 #

如果你的Date字段包含时分秒等时间部分，需要先截断时间保留日期，再进行分组汇总：

SELECT 
    DATE(Date) AS date_only,
    SUM(num_of_questions) AS total_questions,
    SUM(num_of_answers) AS total_answers
FROM StackOverflow
WHERE DATE(Date) BETWEEN '2022-09-01' AND '2022-09-02'
GROUP BY DATE(Date)
ORDER BY date_only;

内容的提问来源于stack exchange，提问作者constantlyFlagged