Mysql GROUP BY严格模式

SELECT SUM(data_soe.resend_num) as sum, count(data_soe.resend_num) as count, v_substation.control_area as xAxis, v_substation.sub_control_area as id
 FROM data_soe
 INNER JOIN v_substation
 ON data_soe.substation_id = v_substation.id
 INNER JOIN measurement
 ON data_soe.measurement_id=measurement.id GROUP BY v_substation.control_area;

该语句使用了聚合函数，group by的字段在查询中也有，但是 查询了v_substation.control_area as xAxis, v_substation.sub_control_area as id两个字段，只GROUP BY v_substation.control_area;

可能一个 v_substation.control_area;对应与id不是一一对应数据库不知道所以必须GROUP BY v_substation.control_area， v_substation.sub_control_area;