mysql分类统计cash when then

SELECT     name as '小区名称',    sum(case when location='inner' then 1 else 0 end) AS '小区内',    sum(case when location='door' then 1 else 0 end) AS '小区门口',     sum(case when location='street' then 1 else 0 end) AS '街道旁',    round(sum(case when location='inner' then 1 else 0 end)/(SELECT count(*) FROM v_shop_community)*100,1) AS '小区内%',    round(sum(case when location='door' then 1 else 0 end)/(SELECT count(*) FROM v_shop_community)*100,1) AS '小区门口%',    round(sum(case when location='street' then 1 else 0 end)/(SELECT count(*) FROM v_shop_community)*100,1) AS '街道旁%'from v_shop_community group by name;