select rownum xh0000, a.zdm000,xt.jbmc00,a.ls0000,zje000,bzcyrs,bzcyfy,hzcrs0,swrs00 from 
                    (select substr(zdm000,1,instr(zdm000,'.')+1) zdm000,count(zd.zdm000) ls0000,sum(zje000) zje000,
sum(case when (select count(1) from zy_brxxb0 zy where ba.lsh000=zy.zyid00 and zy.ffbzbm is not null) >0 then 1 else 0 end) bzcyrs,
sum(case when (select count(1) from zy_brxxb0 zy where ba.lsh000=zy.zyid00 and zy.ffbzbm is not null) >0 then ba.zje000 else 0 end) bzcyfy,
sum(to_date(cyrq00,'YYYYMMDD')-to_date(Ryrq00,'YYYYMMDD')) hzcrs0,
sum(decode(lyfs00,'死亡',1,0)) swrs00
from ba_brzyxx ba join bq_brzdxx zd on ba.lsh000=zd.zyid00 
                    where zdlb00='3' and ba.cyrq00>='20221023' and cyrq00<='20231023' and zdm000 is not null
                    group by substr(zdm000,1,instr(zdm000,'.')+1) order by ls0000 desc ) a join xt_icdxm0 xt on a.zdm000=xt.icdxm0 where rownum<=300