mysql case when 统计状态数量

用法 case xxx when xx then xx else xx end
注意sql 中 as 取别名不能为数字

SELECT 
count(1) as totalnum ,
sum(CASE order_state WHEN 1 THEN 1 ELSE 0 END ) AS newSend,
sum(CASE order_state WHEN 2 THEN 1 ELSE 0 END) as ss,
sum(CASE order_state WHEN 3 THEN 1 ELSE 0 END) as cc,
sum(CASE order_state WHEN 4 THEN 1 ELSE 0 END) as dd,
sum(CASE order_state WHEN 5 THEN 1 ELSE 0 END) as sse,
sum(CASE order_state WHEN 6 THEN 1 ELSE 0 END) as km
FROM t_defect_rectification_order a
where 1=1