mysql - 使用 case 的 mysql 查询输出不符合预期

Question

我有一个 mysql 查询:

select count(srcount) as SR_Count, 
CASE assignee_name
when 'U80040300' then 'ABC'
when 'U80036396' then 'DEF'
when 'U80035831' then 'GHI'
when 'U80042986' then 'JKL'
else 'A'
end as Guys_Name
from data 
GROUP BY assignee_name; 

输出为

SR_COUNT    GUYS_NAME
3         A
5         A
3         GHI
2         DEF
3         ABC
2         JKL

但我希望输出为

 SR_COUNT   GUYS_NAME
    8         A
    3         GHI
    2         DEF
    3         ABC
    2         JKL

这是 SQLFiddle

如有任何帮助，我们将不胜感激。提前致谢..

Answer 1

按 Guys_Name 对结果进行分组>

select count(srcount) as SR_Count, 
CASE assignee_name
when 'U80040300' then 'ABC'
when 'U80036396' then 'DEF'
when 'U80035831' then 'GHI'
when 'U80042986' then 'JKL'
else 'A'
end as Guys_Name
from data 
GROUP BY Guys_Name;