select DATE_FORMAT(`事件发生时间`,'%Y-%m') as times,count(*) as counts from sh_incidentfornms WHERE `创建人`!='顶级管理员' group by DATE_FORMAT(`事件发生时间`,'%Y-%m')having DATE_FORMAT(`事件发生时间`,'%Y-%m') like '2016%'加个having 过滤下
