select rownum XH0000,a.KSBH00,a.BMMC00,a.LJMC00,a.LJID00,
       (select count(distinct b.zyid00)
          from VW_ZY_LJZRZC_ZYDZBL B
         where a.LJID00 = b.LJID00 and b.ljksbh=a.ksbh00
         and SJCYRQ >= '20200316'  and SJCYRQ <='20200416' ) RJRS00, --入径人数
       (select count(distinct b.zyid00)
          from VW_ZY_LJZRZC_ZYDZBL b
         where a.LJID00 = b.LJID00 and b.ljksbh=a.ksbh00
           and SJCYRQ >= '20200316'  and SJCYRQ <='20200416'
           and jsfs00 = '完成') RJWCRS, --完成人数
          (select count(distinct b.zyid00)
          from VW_ZY_LJZRZC_ZYDZBL b
         where a.LJID00 = b.LJID00
           and SJCYRQ >= '20200316'  and SJCYRQ <='20200416' and b.ljksbh=a.ksbh00
           and jsfs00 = '强制退出' and b.zrzcid not in (select d.zrzcid from LJ_BRRJZZ d where d.LJID00 = B.LJID00 )) RJTCRS, --退出人数       (select count(distinct b.zyid00)
          from ZY_BRXXB0 B
         where  B.BRZT00 in('4','5') and B.dqks00=a.KSBH00
            and B.SJCYRQ >= '20200316'  and B.SJCYRQ <='20200416'
            ) CYRS00, --出院院人数       (select count(distinct b.zyid00)
          from VW_ZY_LJZRZC_ZYDZBL B, LJ_BRRJZZ C
         where A.LJID00 = B.LJID00 and b.ljksbh=a.ksbh00
           and B.ZRZCID = C.ZRZCID 
            and SJCYRQ >= '20200316'  and SJCYRQ <='20200416'
           ) RJHPCS, --入径后排除数 
       (select count(distinct b.zyid00)
          from ZY_BRXXB0 B, LJ_BRRJZZ C
         where C.ZYID00 = B.ZYID00
           and C.LJID00 = A.LJID00
           and C.ZRZCID is null
           and B.SJCYRQ >= '20200316'  and B.SJCYRQ <='20200416' ) RJQPCS, --入径前排除数  
           0 SZRS00 ,'' RJL000,'' WCLJBL,'' CYLJGL,
           round(((select count(distinct b.zyid00)
          from VW_ZY_LJZRZC_ZYDZBL b
         where a.LJID00 = b.LJID00
           and SJCYRQ >= '20200316'  and SJCYRQ <='20200416' and b.ljksbh=a.ksbh00
           and jsfs00 = '强制退出' and b.zrzcid not in (select d.zrzcid from LJ_BRRJZZ d where d.LJID00 = B.LJID00 ))/
            (select decode(count(distinct b.zyid00),0,1,count(distinct b.zyid00))
          from VW_ZY_LJZRZC_ZYDZBL B
         where a.LJID00 = b.LJID00 and b.ljksbh=a.ksbh00
         and SJCYRQ >= '20200316'  and SJCYRQ <='20200416' ))*100,2)|| '%' BYL001, --变异率=退出人数/入径人数,
       (select nvl(ROUND(avg(TO_DATE(B.SJCYRQ, 'YYYYMMDD') -TO_DATE(B.RYRQ00, 'YYYYMMDD')),0),0)
          from VW_ZY_LJZRZC_ZYDZBL B
         where A.LJID00 = B.LJID00
           and A.KSBH00 = B.DQKS00 
           and B.SJCYRQ >= '20200316'  and B.SJCYRQ <='20200416'
           and B.JSFS00 = '完成') PJZYTS, --平均住院日=完成路径的病人总天数/人数
           round(((select nvl(sum((select sum(D.HJJE00)
           from ZY_BRFY00 C, ZY_FYMX00 D
           where C.ZYID00 = Z.ZYID00
           and C.DJH000 = D.DJH000)),0)
          from VW_ZY_LJZRZC_ZYDZBL Z
         where A.LJID00 = Z.LJID00
           and A.KSBH00 = Z.DQKS00
           and Z.JSFS00 = '完成'
           and Z.SJCYRQ >= '20200316'  and Z.SJCYRQ <='20200416')/(select decode(count(distinct b.zyid00),0,1,count(distinct b.zyid00))
          from VW_ZY_LJZRZC_ZYDZBL b
         where a.LJID00 = b.LJID00 and b.ljksbh=a.ksbh00
           and SJCYRQ >= '20200316'  and SJCYRQ <='20200416'
           and jsfs00 = '完成')),2) PJZYFY, --平均住院费用=完成总费用/完成人数
            (select round((nvl(sum(trunc(to_date(ss.ssrq00,'yyyy-MM-dd'))-trunc(to_date(zy.ryrq00,'yyyy-MM-dd'))),0)/decode(count(ss.lsh000),0,1,count(ss.lsh000))),2) from VW_ZY_LJZRZC_ZYDZBL lj, ba_brssxx ss,
            zy_brxxb0 zy where  lj.zyid00=zy.zyid00 and lj.ljid00=a.LJID00 and lj.DQKS00=a.ksbh00 and
      lj.zyid00=ss.lsh000 and lj.jsfs00='完成' and ss.ssxh00='1' and zy.sjcyrq>='20200316' and zy.sjcyrq<='20200416') RJSQTS      
            from VW_ZS_KSLJXX_ZYDZBL a where 1=1  order by XH0000,BMMC00