--2
select '特殊使用级抗菌药物占抗菌药物使用量百分率' as mc0000,
round((
(select sum(ROUND(YPZSL0*ZHL000/ddd000,3)) YPSL00 from VW_YK_KSSJB0_QY where kssjb0='3' and JZRQ00
         between '20150101' and '20150131')/ --4511.25
(select sum(ROUND(YPZSL0*ZHL000/ddd000,3)) YPSL00 from VW_YK_KSSJB0_QY where JZRQ00
         between '20150101' and '20150131')--6661686.774
),6)*100 ||'%' from dual         
  
--7
--发药时间内抗菌输液药物总例数，同组输液只算一例 
select count(distinct yzid00) 抗菌输液药物总例数 from yf_yzypsq a,bm_yd0000 b  where fyrq00 between '20150101' and '20150131' and ypyfmc like '%静脉输液%' and a.ypnm00=b.ypnm00 and b.kssjb0<>0

-- 发药时间内输液药物总例数，同组输液只算一例
select count(distinct yzid00) 输液药物总例数 from yf_yzypsq a,bm_yd0000 b  where fyrq00 between '20150101' and '20150131'   and ypyfmc like '%静脉输液%' and a.ypnm00=b.ypnm00  

--以上两句相除取百分比如下：
select '住院患者抗菌药物静脉输液占比' as mc0000,round (
((select count(distinct yzid00) 抗菌输液药物总例数 from yf_yzypsq a,bm_yd0000 b  
where fyrq00 between '20150101' and '20150131' and ypyfmc like '%静脉输液%' and a.ypnm00=b.ypnm00 and b.kssjb0<>0)/
(select count(distinct yzid00) 输液药物总例数 from yf_yzypsq a,bm_yd0000 b  
where fyrq00 between '20150101' and '20150131'   and ypyfmc like '%静脉输液%' and a.ypnm00=b.ypnm00)),2)*100||'%' jmsyzb
from dual 

--8.1
--门诊患者静脉输液使用人次
select count(distinct b.ghh000) 输液药物使用人次 from yf_mzcfmx a,yf_mzcf00 b 
  where a.cflsh0=b.cflsh0 and b.fyrq00 between '20150101' and '20150131' and a.zjyfmc like '%静脉输液%'

--门诊患者总人次  
select sum(TJJG00) from ZH_TJZB00 where TJBH00='0001' and TJRQ00 between '20150101' and '20150131'  

--以上两句相除取百分率如下：
select '门诊患者静脉输液使用率' as mc0000,round (
((select count(distinct b.ghh000) from yf_mzcfmx a,yf_mzcf00 b 
  where a.cflsh0=b.cflsh0 and b.fyrq00 between '20150101' and '20150131' and zjyfmc like '%静脉输液%')/
(select sum(TJJG00) from ZH_TJZB00 where TJBH00='0008' and TJRQ00 between '20150101' and '20150131')),2)*100||'%' mzsyl0
from dual

--8.2
--急诊患者静脉输液使用人次  
select sum(GHCS00) from  VW_SF_GHLSXX c where c.czrq00>='20150101' and c.czrq00<='20150131'  
  and exists (select 1 from yf_mzcfmx b,yf_mzcf00 a where a.GHID00=c.GHID00 and b.cflsh0=a.cflsh0 and zjyfmc like '%静脉输液%') 
  and c.ghlb00 in (select lbbh00 from bm_ghlbb0 where lbbh00=c.ghlb00 and lbmc00 like '%急%')
    
--急诊患者总人次  
select sum(TJJG00) from ZH_TJZB00 where TJBH00='0002' and TJRQ00 between '20150101' and '20150131'

--以上两句相除取百分率如下：
select '急诊患者静脉输液使用率' as mc0000,round (  
((select sum(GHCS00) from  VW_SF_GHLSXX c where c.czrq00>='20150101' and c.czrq00<='20150131'  
  and exists (select 1 from yf_mzcfmx b,yf_mzcf00 a where a.GHID00=c.GHID00 and b.cflsh0=a.cflsh0 and zjyfmc like '%静脉输液%') 
  and c.ghlb00 in (select lbbh00 from bm_ghlbb0 where lbbh00=c.ghlb00 and lbmc00 like '%急%'))/ 
(select sum(TJJG00) from ZH_TJZB00 where TJBH00='0002' and TJRQ00 between '20150101' and '20150131')),2)*100||'%' jzsyl0
from dual

--8.3
-- 发药时间内输液药物总例数，同组输液只算一例
select count(distinct yzid00) 输液药物总例数 from yf_yzypsq a,bm_yd0000 b  
where fyrq00 between '20150101' and '20150131'   and ypyfmc like '%静脉输液%' and a.ypnm00=b.ypnm00  

-- 发药时间内药物总例数，同组用药只算一例
select count(distinct yzid00) 药物总例数 from yf_yzypsq a,bm_yd0000 b  
where fyrq00 between '20150101' and '20150131'  and a.ypnm00=b.ypnm00  

--以上两句相除取百分比如下：
select '住院患者静脉输液使用率' as mc0000,round (
((select count(distinct yzid00) 输液药物总例数 from yf_yzypsq a,bm_yd0000 b  
        where fyrq00 between '20150101' and '20150131'   and ypyfmc like '%静脉输液%' and a.ypnm00=b.ypnm00)/
(select count(distinct yzid00) 药物总例数 from yf_yzypsq a,bm_yd0000 b  
        where fyrq00 between '20150101' and '20150131'  and a.ypnm00=b.ypnm00)),2)*100||'%' jmsyzb
from dual

--9
--发药时间内 静脉输液 用药总袋（瓶） 数 
select sum(YPZSL0) 用药总数量 from yf_yzypsq  where fyrq00 between '20150101' and '20150131' and ypyfmc like '%静脉输液%' 

--统计时间内 每天在院人数合计 
select sum(tjjg00) 占用床日数 from ZH_TJZB00 where czrq00 between '20150101' and '20150131'  and tjbh00='0013'

--以上两句相除如下：
select '住院患者静脉输液平均每床日使用袋（瓶）数' as mc0000,round (
((select sum(YPZSL0) 用药总数量 from yf_yzypsq  
       where fyrq00 between '20150101' and '20150131' and ypyfmc like '%静脉输液%')/ 
(select sum(tjjg00) 占用床日数 from ZH_TJZB00 
       where czrq00 between '20150101' and '20150131'  and tjbh00='0013')),2) mcrds0
from dual