MySql同一张表各个状态的项目数量筛选查询

表中有几个可以筛选的字段：is_locked, is_finished, is_deleted,如果用一条sql语句同时统计这个表中的所有状态的项目的数量：

SELECT count(table.id) as total,

count(CASE table.is_finished WHEN 1 THEN 1 END) AS finished,

count(CASE table.is_locked WHEN 0 THEN 1 END ) AS unlocked,

count（CASE table.is_deleted WHEN 1 THEN 1 END ) AS deleted

FROM table;

查询结果：

total    finished   unlocked   deleted

100         30            30                2