嵌套Sql语句，大家帮忙看看 这么写？

[java_mp5]

HEALTH_JK_CheckResult
就这一张表。
想实现，根据一定的条件count出信息 作为一列，类似如下的样子，但是这样报错。请问怎么写？

select count(select * from HEALTH_JK_CheckResult where charindex('血脂升高',chkresult)>0) as xuezhisg,

count(*) as gaoxuey
from HEALTH_JK_CheckResult

[中国风]

count放在子查询里面
select   

(select   count(*)   from   HEALTH_JK_CheckResult   where   charindex('血脂升高',chkresult)> 0)   as   xuezhisg,  as   gaoxuey   
  from   HEALTH_JK_CheckResult

[中国风]

select   
count(select   *   from   HEALTH_JK_CheckResult   where   charindex('血脂升高',chkresult)> 0)   as   xuezhisg, 

count(*)   as   gaoxuey   
  from   HEALTH_JK_CheckResult

[java_mp5]

还是不行。。
count(*) as gaoxuey
这个里面的*也是类似上面的查询语句

[java_mp5]

好了，
select

(select count(*) from HEALTH_JK_CheckResult where charindex('血脂升高',chkresult)> 0) as xuezhisg,
(select count(*) from HEALTH_JK_CheckResult where charindex('胆囊疾患',chkresult)>0) as dannangjh
from HEALTH_JK_CheckResult
就这样的。。
谢谢啊 马上给分。

[kk19840210]

select   (select  count(*)   from   HEALTH_JK_CheckResult   where   charindex('血脂升高',chkresult)> 0)   as   xuezhisg,
count(*)   as   gaoxuey   
  from   HEALTH_JK_CheckResult