create or replace view sd_hospital.vw_emr_nursingdays as
select b.zyid00 IPID,
count(DECODE(a.XMMC00,'特级护理',0))SPECIAL_CARE_DAYS,
count(DECODE(a.XMMC00,'Ⅰ级护理',0))ONE_GREAD_CARE_DAYS,
count(DECODE(a.XMMC00,'Ⅱ级护理',0))TWO_GREAD_CARE_DAYS,
count(DECODE(a.XMMC00,'Ⅲ级护理',0))THREE_GREAD_CARE_DAYS
 from zy_fymx00 a,zy_brfy00 b where a.djh000=b.djh000  and   a.XMBH00 in (20133,20134,20135,20136)  and a.cxbz00='Z'
 group by  b.zyid00;