MySQL 查询 : count entries by status

Question

我有一个具有以下架构的日志表:

OperatorId - JobId - Status ( Good/Bad/Ugly )
Alex         6       Good
Alex         7       Good
James        6       Bad

描述:每当运算符(operator)处理一项工作时，都会生成一个条目以及状态。就是这样。

现在我需要这样的报告:

OperatorId - Good Count - Bad Count - Ugly Count
Alex         2            0           0
James        0            1           0

Answer 1

select operatorid,
sum(if(status="good",1,0)) as good,
sum(if(status="bad",1,0)) as bad,
sum(if(status="ugly",1,0)) as ugly
from table
group by operatorid