/* Formatted on 2021/08/20 09:18 (Formatter Plus v4.8.7) */
SELECT   czyxm0, SUM (jfje00) sje000, COUNT (*) scount
    FROM zy_brjfb0
   WHERE jfje00 > 0
     AND jfczy0 IN ('575', '27', '592', '453')
     AND zffs00 IN (1, 2, 8, 24, 25)
     AND jfrq00 >= :开始
     AND jfrq00 <= :结束
     AND pjh000 IN (SELECT pjh000
                      FROM zy_pjsyqk
                     WHERE plbh00 IN (4, 8))
GROUP BY czyxm0
UNION ALL
SELECT   czyxm0, SUM (jfje00) sje000, COUNT (*) zcount
    FROM zy_brjfb0
   WHERE jfje00 < 0
     AND jfczy0 IN ('575', '27', '592', '453')
     AND zffs00 IN (1, 2, 8, 24, 25)
     AND jfrq00 >= :开始
     AND jfrq00 <= :结束
     AND pjh000 IN (SELECT pjh000
                      FROM zy_pjsyqk
                     WHERE plbh00 IN (4, 8))
GROUP BY czyxm0