为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:dm8
【操作系统】：windows
【CPU】:
【问题描述】：
select a.xqmc,a.jz,count() jws, sum(CAST(b.jwdys AS numeric)) as dys from MHFG_DWD.DWD_T_JW_XQ_TXT a
left join
MHFG_DWD.DWD_T_HSWY_DZZ_INFO_TXT b
on a.jwbm=b.jwbm where xqmc is not null group by a.xqmc,a.jz
是不是写的有问题，试试这个：
select
a.xqmc ,
a.jz ,
count(a.jws) ,
sum(CAST(b.jwdys AS numeric)) as dys
from
MHFG_DWD.DWD_T_JW_XQ_TXT a
left join MHFG_DWD.DWD_T_HSWY_DZZ_INFO_TXT b
on
a.jwbm=b.jwbm
where
xqmc is not null
group by
a.xqmc,
a.jz;