SELECT B.ZWXM00 SFYXM0,SUM(decode(C.ICKLB0,'0',decode(YWCZ00,'1',1,0),0)) SCSL,SUM(decode(C.ICKLB0,'2',decode(YWCZ00,'1',1,0),0)) SYBK,SUM(decode(YWCZ00,'5',1,'C',1,'D',1,0)) HSSL,
 SUM(decode(YWCZ00,'3',1,0)) GSSL,SUM(decode(YWCZ00,'4',1,0)) ZFSL from  IC_YWLS00 A,BM_YGBM00 B,IC_YHXX00 C
 where A.YGBH00=B.YGBH00 AND A.ICKH00=C.ICKH00  and  CZRQ00 >= '20200701' and  CZRQ00 <= '20200803' and  CZRQ00||CZSJ00 >= '2020070100:00:00' and  CZRQ00||CZSJ00 <= '2020080323:59:59'
 group by B.ZWXM00 
union all
SELECT 'ºÏ  ¼Æ' SFYXM0,SUM(decode(C.ICKLB0,'0',decode(YWCZ00,'1',1,0),0)) SCSL,SUM(decode(C.ICKLB0,'2',decode(YWCZ00,'1',1,0),0)) SYBK,SUM(decode(YWCZ00,'5',1,'C',1,'D',1,0)) HSSL,
 SUM(decode(YWCZ00,'3',1,0)) GSSL,SUM(decode(YWCZ00,'4',1,0)) ZFSL from  IC_YWLS00 A,BM_YGBM00 B,IC_YHXX00 C
 where A.YGBH00=B.YGBH00 AND A.ICKH00=C.ICKH00  and  CZRQ00 >= '20200701' and  CZRQ00 <= '20200803' and  CZRQ00||CZSJ00 >= '2020070100:00:00' and  CZRQ00||CZSJ00 <= '2020080323:59:59'