mysql 分组统计

		SELECT
			batNo,
			COUNT(id) AS count,                                                                 #统计总数 
			SUM(case when abnomal = 2 then 1 else 0 end) as excCount,                           #统计abnomal=2(异常)的总数 
			SUM(matTheWei) AS sumMatTheWei,                                                     #求和
			SUM(matPraWei) AS sumMatPraWei,
            AVG(case when abnomal <> 2 then negativeRate else 0 end) AS countNegativeRate,      #统计 abnomal!= 2(正常)的平均数 
			AVG(negativeRate) AS avgNegativeRate,                                               #统计所有平均数
			MIN(rollingDate) AS minRollingDate,                                                 #最小值
			classCode
		FROM 
			sys_plan_bet
		WHERE 1=1
		GROUP BY batNo 	
		ORDER BY batNo desc