关于楼上的问题，我也遇到过，老哥方便的话请看看，没有嵌套子查询，并直接使用GROUPING和CASE WHEN来做，会出现full group by错误： SELECT CASE WHEN GROUPING(DATE_FORMAT(submit_time, "%Y%m")) = 1 THEN '2021汇总' ELSE DATE_FORMAT(submit_time, "%Y%m") END AS submit_month, COUNT(submit_time) AS month_q_cnt, ROUND(COUNT(submit_time) / MAX(DAY(LAST_DAY(submit_time))), 3) AS avg_day_q_cnt FROM practice_record WHERE YEAR(submit_time) = 2021 GROUP BY DATE_FORMAT(submit_time, "%Y%m") WITH ROLLUP