count条件查询求解解决方案

CREATE TABLE [rjh] (    [id] [decimal](18, 0) IDENTITY (1, 1) NOT NULL ,    [d_id] [decimal](18, 0) NOT NULL ,    [rq] [datetime] NOT NULL ,    [jth] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,    [bcl] [int] NULL ,    [zhong] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,    [ye] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,    [zao] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,    [bz] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]insert into rjh(d_id,rq,jth,bcl,zhong,ye,zao,bz) values(1,'2012-3-26','c11',550,'','停','','')insert into rjh(d_id,rq,jth,bcl,zhong,ye,zao,bz) values(5,'2012-3-26','c12',650,'','','停','停')insert into rjh(d_id,rq,jth,bcl,zhong,ye,zao,bz) values(5,'2012-3-26','c13',750,'','停','','停')insert into rjh(d_id,rq,jth,bcl,zhong,ye,zao,bz) values(4,'2012-3-26','c14',850,'','','','停')insert into rjh(d_id,rq,jth,bcl,zhong,ye,zao,bz) values(5,'2012-3-26','c15',550,'','','停','')insert into rjh(d_id,rq,jth,bcl,zhong,ye,zao,bz) values(5,'2012-3-26','c16',450,'','','','')insert into rjh(d_id,rq,jth,bcl,zhong,ye,zao,bz) values(4,'2012-3-26','c14',850,'','','','停')insert into rjh(d_id,rq,jth,bcl,zhong,ye,zao,bz) values(5,'2012-3-26','c15',550,'','','停','')insert into rjh(d_id,rq,jth,bcl,zhong,ye,zao,bz) values(6,'2012-3-26','c16',450,'','','','')GO需要查询出 where d_id=5 ,  zhong,ye,zao 3个字段等于'停'的个数总和  结果应该是 6 ,求教怎么写sql语句

select sum(case when zhong='停' then 1 else 0 end)+ sum(case when ye='停' then 1 else 0 end)+ sum(case when zao='停' then 1 else 0 end) from tb  where d_id=5