--did
--一、教学及辅助用房2
--教室3
--图书馆4
--实验室、实习场所5
--体育馆6
--会堂7
--二、行政办公用房8
--三、生活用房9
--学生宿舍（公寓）10
--学生食堂11
--教工宿舍（公寓）12
--教工食堂13
--生活福利及附属用房14
--四、教工住宅15
--五、其他用房16

select sbr.organizationNo  ,1 as schoolTypeGroupNo,'一、高中阶段' as schoolTypeGroup,2 as schoolTypeGroupNo2,'（二）中等职业学校' as schoolTypeGroup2 ,sbr.businessTypeNo,case when sbr.businessTypeNo in ('368','369') then '其他机构（班）' else sbr.businessType end as  businessType 
, sbr.isCount , sum(d) as d,sum(e) as e, sum(f) as f,sum(g) as g , sum(h) as h, sum(j) as j,sum(k) as k , did
from  schoolBusinessRelation sbr 
inner join instanceTable it on sbr.organizationNo =it.organizationNo and sbr.businesstypeno =it.businesstypeno 
inner join Z511 as j on j.instanceid =it.instanceid and did between 2 and 16  
where  sbr.gatherRegionB ='长春市'  and sbr.businessTypeNo  in('362','364','365','369','361','363')  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.citycountrytypeno ,sbr.cityCountryGroup,did
order by sbr.businessTypeNo;