This file contains ambiguous Unicode characters that may be confused with others in your current locale. If your use case is intentional and legitimate, you can safely ignore this warning. Use the Escape button to highlight these characters.
--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
