------------------------------电子凭证使用率----------------------------------------------------------- 

-----------------------按挂号医生---------------------------------- 

select ghyxm0,sum(dzpzjs),sum(zjs),round(sum(dzpzjs)/sum(zjs),4)*100||'%' dzpzjsl from ( 
SELECT b.ghyxm0 ,count(*) dzpzjs,0 zjs FROM sf_jzb000 a,sf_brxxb0 b
         WHERE a.mzid00=b.ghid00 and a.jzrq00 BETWEEN '20240101' AND '20240431'
           AND a.bke284 = '06' 
           group by b.ghyxm0 
           
UNION ALL

SELECT b.ghyxm0 ,0,count(*) zjs FROM sf_jzb000 a,sf_brxxb0 b
         WHERE a.mzid00=b.ghid00 and a.jzrq00 BETWEEN '20240101' AND '20240431'
           AND a.ybdjh0<>'0' group by b.ghyxm0  
   )        
group by  ghyxm0  order by sum(zjs) desc     


------------------------按挂号科室-----------------------     


select bmmc00,sum(dzpzjs),sum(zjs),round(sum(dzpzjs)/sum(zjs),4)*100||'%' dzpzjsl from ( 
SELECT c.bmmc00 ,count(*) dzpzjs,0 zjs FROM sf_jzb000 a,sf_brxxb0 b,bm_bmbm00 c
         WHERE a.mzid00=b.ghid00 and b.ghks00=c.bmbh00 and a.jzrq00 BETWEEN '20240101' AND '20240431'
           AND a.bke284 = '06' group by c.bmmc00 
           
UNION ALL

SELECT c.bmmc00 ,0,count(*) zjs FROM sf_jzb000 a,sf_brxxb0 b,bm_bmbm00 c
         WHERE a.mzid00=b.ghid00 and b.ghks00=c.bmbh00 and a.jzrq00 BETWEEN '20240101' AND '20240431'
           AND a.ybdjh0<>'0' group by c.bmmc00
   )        
group by  bmmc00   order by sum(zjs) desc

   
----------------------------------移动支付------------------------------------------------------------------------

-----------------------按挂号医生---------------------------------- 
select ghyxm0,sum(dzpzjs),sum(zjs),round(sum(dzpzjs)/sum(zjs),4)*100||'%' dzpzjsl from ( 
SELECT b.ghyxm0 ,count(*) dzpzjs,0 zjs FROM sf_jzb000 a,sf_brxxb0 b
         WHERE a.mzid00=b.ghid00 and a.jzrq00 BETWEEN '20240101' AND '20240431'
           AND a.jzy000=3045
           group by b.ghyxm0 
           
UNION ALL

SELECT b.ghyxm0 ,0,count(*) zjs FROM sf_jzb000 a,sf_brxxb0 b
         WHERE a.mzid00=b.ghid00 and a.jzrq00 BETWEEN '20240101' AND '20240431'
           AND a.ybdjh0<>'0' group by b.ghyxm0  
   )        
group by  ghyxm0  order by sum(zjs) desc     


------------------------按挂号科室-----------------------     


select bmmc00,sum(dzpzjs),sum(zjs),round(sum(dzpzjs)/sum(zjs),4)*100||'%' dzpzjsl from ( 
SELECT c.bmmc00 ,count(*) dzpzjs,0 zjs FROM sf_jzb000 a,sf_brxxb0 b,bm_bmbm00 c
         WHERE a.mzid00=b.ghid00 and b.ghks00=c.bmbh00 and a.jzrq00 BETWEEN '20240101' AND '20240431'
           AND a.jzy000=3045 group by c.bmmc00 
           
UNION ALL

SELECT c.bmmc00 ,0,count(*) zjs FROM sf_jzb000 a,sf_brxxb0 b,bm_bmbm00 c
         WHERE a.mzid00=b.ghid00 and b.ghks00=c.bmbh00 and a.jzrq00 BETWEEN '20240101' AND '20240431'
           AND a.ybdjh0<>'0' group by c.bmmc00
   )        
group by  bmmc00   order by sum(zjs) desc