select xmdadocno as 订单号, xmdadocdt as 订单日期 , xmdastus as 状态码, xmda041 as 税前金额, xmda042 as 含税金额, sum(xmda041) as 税前总金额, sum(xmda042) as 含税总金额, sum((case when xmdastus='Y' then '1' else '0' end )) as 已审核合同, sum((case when xmdastus='N' then '1' else '0' end )) as 未审核合同, sum((case when xmdastus='C' then '1' else '0' end )) as 已结案合同 from xmda_t where xmdastus<>'X' group by xmdadocdt, xmdastus, xmda041, xmda042, xmdadocno 上面一段代码中 sum((case when xmdastus='Y' then '1' else '0' end )) as 已审核合同, sum((case when xmdastus='N' then '1' else '0' end )) as 未审核合同, sum((case when xmdastus='C' then '1' else '0' end )) as 已结案合同 想用这段代码 来算出 已审合同有多少笔 未审合同多少笔 已结案合同多少笔 但是查询出来的结果没有 显示 是我的写得有问题 请大佬们赐教