select sum(ID) as quantity,
year(GMT_CREATED) as gyear,
quarter(GMT_CREATED) as gquarter
from TABLE1 as t1
where t1.STATUS='正常'
group by gyear,gquarter
转载于:https://my.oschina.net/jingshishengxu/blog/806743