--did
--女3
--少数民族4
--研究生毕业5
--本科毕业6
--专科毕业7
--高中阶段毕业8
--高中阶段以下毕业9
 
SELECT sbr.organizationNo  ,2 as schoolTypeGroupNo,'二、义务教育' as schoolTypeGroup,2 as schoolTypeGroupNo2,'（二）初中阶段' as schoolTypeGroup2 ,sbr.businessTypeNo,sbr.businessType 
,sbr.ownertypeno ,sbr.ownerTypeGroup ,sbr.citycountrytypeno ,sbr.cityCountryGroup,sbr.structureType,sbr.populationGroup,sbr .isnation 
,case when sbr.businessTypeNo='341' then 0  when sbr.businessTypeNo='345' then 0 else 1 end as isCount  ,  
sum(F + G + H + I + M + N + O + P + Q + R + S + T + U + V + W + X + Y + Z + AC + AD) as teacherNO 
,did,sum(F) ,sum(G) ,sum(H) ,sum(I) ,sum(J) ,sum(K) ,sum(L) ,sum(M) ,sum(N) ,sum(O) ,sum(P) ,sum(Q) ,sum(R) ,sum(S) ,sum(T) ,sum(U) 
,sum(V) ,sum(W) ,sum(X) ,sum(Y) ,sum(Z) ,sum(AA) ,sum(AB) ,sum(AC) ,sum(AD)
from schoolBusinessRelation sbr 
inner join instanceTable it on sbr.organizationNo =it.organizationNo and sbr.businesstypeno =it.businesstypeno 
inner join J424 as j on j.instanceid =it.instanceid  and  did in (3,4,5,6,7,8,9)
where  sbr.gatherRegionB ='长春市'  and sbr.businessTypeNo in('311','312','321','341','345')   and sbr.isLastYearCancel =0  and sbr.recordyear =2019 and it.recordyear =2019 and j.recordyear =2019
group by sbr.organizationNo,sbr.businessTypeNo,sbr.businessType ,sbr.isCount,sbr.ownertypeno ,sbr.ownerTypeGroup ,sbr.citycountrytypeno ,sbr.cityCountryGroup,sbr.structureType,sbr.populationGroup,sbr .isnation,did 
order by sbr.businessTypeNo;