mysql统计分组求和1、由于工作需要对数据进行一个分组展示汇总处理，之前的处理情况如下：SELECTa.qxmc as ‘区县’,count()as ‘下发数’,SUM(b.sflxs is not null) as ‘核查数’,SUM(b.sflxs is not null)/count()as ‘完成率’,SUM(b.sflxs=1 and b.sfchbl=1 and b.szdq=1)