How to use a sentence of SQL, statistics of the number of rows in different states?

The data in the database is this:

The filtered data is this:

How to use a sentence of SQL, the data from the database to filter out the results of the implementation?

Solve:

select 系统名称, sum ( case when 故障状态= ‘已处理‘ then 1  else 0  end )  as 已处理个数, sum ( case when 故障状态= ‘未处理‘ then 1  else 0  end )  as 未处理个数, count (*)  as 总个数 from 表名

groupby系统名称

Links: http://zhidao.baidu.com/link?url=UyNCB4lHhQ9xCy-QInSyVRGHoWKxWy1h6GP8g688OFy8099Bz9XcrbEf_xIjz4V2_kc4XZpaBinrMea3ghoFv_