mysql 如何统计一季度数据

[gshj121]

mysql 如何统计一季度数据，表时间字段为：savetime

[百年树人]

group by concat(date_format(savetime, '%Y '),FLOOR((date_format(savetime, '%m ')+2)/3))

[ACMAIN_CHM]

select YEAR(savetime)*10+((MONTH(savetime)-1) DIV 3) +1,count(*)
from yourTable
group by YEAR(savetime)*10+((MONTH(savetime)-1) DIV 3) +1;