SELECT SUBSTR(S.XMMC00||DECODE(S.JSXM00,'2',decode(S.GG0000,null,null,'['||S.GG0000||']'),decode(max(S.BZ0000),null,null,'['||max(S.BZ0000)||']')),0,120 ) XMMC00  ,trim(S.DW0000) DW0000,S.SFJE00,M.XMDJ00,SUM(M.XMSL00) SL0000,SUM(M.HJJE00) HJJE00,P.XMMC00 FPXMMC, '20230801 00:00'||'至'||'20240902 23:59' CZRQ00 FROM   ZY_FYMX00 M,ZY_BRFY00  F,BM_YYSFXM S,BM_FPXM00 P WHERE  M.DJH000=F.DJH000 AND M.XMBH00=S.SFXMID AND S.ZYFPID=P.FPXMID  and M.SFLB00 != '3' and F.CZRQ00 >= '20230801'  and F.CZRQ00||' '||F.CZSJ00 >= '20230801 00:00:00'  and F.CZRQ00 <='20240902'  and F.CZRQ00||' '||F.CZSJ00 <='20240902 23:59:59'  AND M.ZXKS00 IN (SELECT KSH000 FROM BM_BQKS00 WHERE BQH000='240') AND M.KDBQ00 >= 0 GROUP BY S.XMMC00,S.JSXM00,S.GG0000,S.DW0000,S.BZ0000,S.SFJE00,M.XMDJ00,P.XMMC00  ORDER BY P.XMMC00,S.XMMC00