
select SUM(A.FPHJJE) FPHJJE ,A.FPXMMC  from VW_ZY_RQDFPXMHZ A ,ZY_BRXXB0 B  where A.ZYID00=B.ZYID00  AND B.BRZT00<>'3' 
and A.QDH000 in ( '0','20240411','20240412','20240413','20240414','20240415','20240416','20240417','20240418','20240419',
'20240420','20240421','20240422' )  and  A.ZYH000  in ( '0','24031870' )
group  by  A.FPXMMC 
