--学校数 + 学生数
SELECT sbr.organizationNo  ,3 as schoolTypeGroupNo,'三、特殊教育' as schoolTypeGroup,0 as schoolTypeGroupNo2,'' as schoolTypeGroup2 ,sbr.businessTypeNo,sbr.businessType 
,sbr.ownertypeno ,sbr.ownerTypeGroup ,sbr.citycountrytypeno ,sbr.cityCountryGroup,sbr.structureType,sbr.populationGroup,sbr .isnation 
, sbr.isCount, sum(f) as zhaoshengNo,sum(I + J + K + L + M + N + O + P + Q + R + S + T + U + V) as zaixiaoNo,sum(e) as biyeNo,sum(h) as nvNo,
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)
from schoolBusinessRelation sbr 
inner join instanceTable it on sbr.organizationNo =it.organizationNo and sbr.businesstypeno =it.businesstypeno 
inner join J315 as j on j.instanceid =it.instanceid and  did between 16 and 22
where  sbr.gatherRegionB ='长春市'  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 
order by sbr.businessTypeNo;

--did
-- 女 2
-- 少数民族3
-- 寄宿生4
-- 职业技术班5

SELECT sbr.organizationNo  ,3 as schoolTypeGroupNo,'三、特殊教育' as schoolTypeGroup,0 as schoolTypeGroupNo2,'' as schoolTypeGroup2 ,sbr.businessTypeNo,sbr.businessType 
,sbr.ownertypeno ,sbr.ownerTypeGroup ,sbr.citycountrytypeno ,sbr.cityCountryGroup,sbr.structureType,sbr.populationGroup,sbr .isnation 
, sbr.isCount, sum(f) as zhaoshengNo,sum(I + J + K + L + M + N + O + P + Q + R + S + T + U + V) as zaixiaoNo,sum(e) as biyeNo,sum(h) as nvNo,
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),did
from schoolBusinessRelation sbr 
inner join instanceTable it on sbr.organizationNo =it.organizationNo and sbr.businesstypeno =it.businesstypeno 
inner join J315 as j on j.instanceid =it.instanceid and  did in(2,3,4,5)
where  sbr.gatherRegionB ='长春市'  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;

--班级数
SELECT sbr.organizationNo  ,3 as schoolTypeGroupNo,'三、特殊教育' as schoolTypeGroup,0 as schoolTypeGroupNo2,'' as schoolTypeGroup2 ,sbr.businessTypeNo,sbr.businessType 
,sbr.ownertypeno ,sbr.ownerTypeGroup ,sbr.citycountrytypeno ,sbr.cityCountryGroup,sbr.structureType,sbr.populationGroup,sbr .isnation 
, sbr.isCount,sum(e+f+g+h+I + J + K + L + M + N + O + P + Q +R) as classNo
from schoolBusinessRelation sbr 
inner join instanceTable it on sbr.organizationNo =it.organizationNo and sbr.businesstypeno =it.businesstypeno 
inner join J214 as j on j.instanceid =it.instanceid and  did in(2,3,4,5,6,7,8)
where  sbr.gatherRegionB ='长春市'  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 
order by sbr.businessTypeNo;