select a.plbh00,sum(a.xjje00+a.zzje00) pjje00,count(*) pjsl00 from sf_pjsyqk a,bm_pjlyqk b where 
 a.pjlyid=b.pjlyid
 and a.pjzt00='0' and a.sfdy00='Y' and a.plbh00='1'  and  a.pjxh00 
 between '22737201' and '22737230' group by a.plbh00