comesuh的博客

[Err] 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'dps_test.qm_audit_plan_order.scheduled_end_time' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=on

sum(case 属性名 when 属性值1 then 1 else 0 end)，意思就是某个属性下为属性值1就加1个数量，否则就作0统计。